Monday, April 1, 2019

Add month to date in excel

Formula is as below: 
=EDATE(A1,1)
Here A1 is the cell containing previous date. 
After entering above formula, you will get an integer value. 
Use format cell option in right click menu, and set as date. This will correctly show the date. 
Then we can drag this down for further repetition. 

No comments:

Post a Comment