Thanks friends, Please help modify the formula to read dd-mmm-yyyy

"CLR" wrote:

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



"Afolabi" wrote:

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.