How to set date as 01st of next month of a given date in (dd-mm-yyyy

Hello Everybody!

This is Krishna. I need your help regarding a prob lem.
I have one column where i want to put "DD Date" or Cheque date and in the immediate next column cell i want to claculate "Cover Date" which must be 1st of next month of DD date.

For example: if DD date is 14/01/2007 then cover date must be 01/02/2007 or if DD date is 18/01/2007 cover date must be 01/02/2007.
If dd date is 14/12/2007 then cover date must be 01/01/2008.

Thus pattern is cover date must be 01st of next month of dd date.

Could u pls help me out. I will be thankful to you a lot.

Regards,

Krishna

If DD date is in A1 you could use either of these formulas to generate the first of the following month

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

=EOMONTH(A1,0)+1

EOMONTH is an Analysis ToolPak add-in function (unless you have Excel 2007)