anything in Excel...

It's Excel-o-lozy...

Excel 2003: 1st of next month - How to calculate 1st day of next month from a specified date.

In the previous post we calculated the "1st day of next month from a specified date in Excel 2007"...

BUT how to do it in Excel 2003?

Reason being formula "EOMONTH" is not available in Excel 2003.

e.g. Cell A1 contains "02 Feb 2012" as specified date..

and result should be "01 Mar 2012"…


again I ll say it's Easy…

use this formula "=DATE(YEAR(A1),MONTH(A1)+1,1)"

DATE is a formula for calculating Date by converting Year, Month and Day respectively.

Year is taken same, "+1" is added to Month, and Date is fixed as 1 respectively.

Super duper simple... isn't it???  ;)

0 comments: