Sunday, January 4, 2009

Excel date mathematics

Microsoft Excel stores dates as sequential numbers known as serial values. Excel stores times as decimal fractions because time is considered a portion of a day.

Dates and times are values and, therefore, can be added, subtracted, and included in other calculations. Will tell you date mathematics formula.


How to Add / Subtract month from a date in Excel.
Adding / Subtracting a month from a particular date in excel looks tough as each month has different number of days. However it is very simple if you use following formula.
=DATE(YEAR(C4),MONTH(C4)+1,DAY(C4))

In this base date is available at cell C4 and we have added 1 to month value to increase it by one month. Similarly you can subtract required number of months from base date. See picture below for further understanding of it.


Addition of more than 12 months will result into addition of year. See picture below:-



Addition of 15 months have resulted into increase of one year and 3 months.

This will work for Year addition / subtraction also.





Date Add , Date Function , excel date mathematics , Excel Date math , using date , excel date calculate , excel date calculation , excel date function , excel date functions

1 comment:

  1. The King Casino: Best Casino Software and Games
    The King ventureberg.com/ Casino software company https://jancasino.com/review/merit-casino/ is well-known in the world of online kadangpintar casino games. It nba매니아 has been in business since 2001, but it now offers live dealer casino 토토 사이트 모음 games

    ReplyDelete

Learn how to create Excel dashboards.
Yogesh Gupta's Excel Tips