Sequential dates.

A

Afolabi

I want a simple formula that will return the next month on a column. while
maintaining the day as 25th of every month.
I mean 25 Nov 2005, 25 Dec 2005, 25 Jan 2006, 25 Feb 2006 and so on....
regards.
 
D

dvtapse

From edit menu click fill then select series and click month so you will
get dates by monthly
 
C

CLR

With your date in A1, put this in B1 and copy across......

=IF(MONTH(A1)=12,1&"/"&DAY(A1)&"/"&YEAR(A1)+1,MONTH(A1)+1&"/"&DAY(A1)&"/"&YEAR(A1))

This way, whenever you change the date in A1, all the other columns follow....

Vaya con Dios,
Chuck, CABGx3
 
A

Afolabi

Thanks for the prompt response. with your method, if I click and drag the
last entry, the result is not in line with my expectation. hence my need for
a FORMULA.
 
M

Max

Afolabi said:
I want a simple formula that will return the next month on a column. while
maintaining the day as 25th of every month.
I mean 25 Nov 2005, 25 Dec 2005, 25 Jan 2006, 25 Feb 2006 and so on....
Click to expand...

Another play ..

With A1 housing a commencement date,
put in B1: =DATE(YEAR($A$1),MONTH($A$1)+COLUMN(A1),25)
Copy B1 across as far as required

To increment copying down, just change COLUMN(A1) to ROW(A1)
eg: place in A2: =DATE(YEAR($A$1),MONTH($A$1)+ROW(A1),25)
Copy A2 down as far as required
 
C

CLR

Use this instead, then you can format the cells for a display of however you
wish.

=IF(MONTH(A1)=12,1&"/"&DAY(A1)&"/"&YEAR(A1)+1,MONTH(A1)+1&"/"&DAY(A1)&"/"&YEAR(A1))*1

Vaya con Dios,
Chuck, CABGx3
 
A

Afolabi

Thanks Max, it works! I only replaced "COLUMN" or "ROW" with +1 to get the
right results .
i.e
=DATE(YEAR(A1),MONTH(A1)+1,25)

Thanks once more.
 
Top