I asked a similar question yesterday, but today I need the excel formula for adding dates, when the dates are in month-end format.
for example, I want:
2/28/10
3/31/10
4/30/10
5/31/10
6/30/10
7/31/10
but copied down in a formula.
thanks!
I asked a similar question yesterday, but today I need the excel formula for adding dates, when the dates are in month-end format.
for example, I want:
2/28/10
3/31/10
4/30/10
5/31/10
6/30/10
7/31/10
but copied down in a formula.
thanks!
Try
=DATE(YEAR(TODAY()),ROW(A2)+1,0)
Perfect!
Is there also a formula that would add dates if they were the 1st of the month?
example:
1/1/10
2/1/10
3/1/10, etc..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks