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