Date of Next month in Excel

[spycein]

Hi Everyone,

i am looking for a formula which works as below mentioned example:-

if i write any random date of specific month in Cell "A1", the cell "A2" should return the value as 5th day of next month.

For example, if i write any dates of March 2015 in "A1", then "A2" value should be 5th April 2015.

Similarly if i write 28/08/15 or 16/08/15 or 31/08/15 then "A2" cell should return the value as 05/09/15.

Thank you in advance.

Shib

 

[Rick Rothstein]

i am looking for a formula which works as below mentioned example:-

if i write any random date of specific month in Cell "A1", the cell "A2" should return the value as 5th day of next month.

For example, if i write any dates of March 2015 in "A1", then "A2" value should be 5th April 2015.

Similarly if i write 28/08/15 or 16/08/15 or 31/08/15 then "A2" cell should return the value as 05/09/15.

Give this formula a try...

=DATE(YEAR(A1),MONTH(A1)+1,5)

 

[spycein]

Thank you very much Mr.Rick Rothstein, works like a charm.