Hi,

I have a Spreadsheet as follows and used a DATEDIF formula to return the number of months:


01-Jan-12 29-Mar-12 3
01-Jan-12 29-Mar-12 3
01-Jan-12 29-Mar-12 3

=IF(DATEDIF(A4,B4,"m")=0,"",DATEDIF(A4,B4,"m"))+CE ILING(DATEDIF(A4,B4,"md")/30,0.5)&""

I would like to add another column which if for example todays date is within the month of January it will return the remaining months of 2 etc.

Rather copying the current formula than adding to it, would I be better off creating a fresh one in the new cell, if so what would you recommend?

If it is best to add to the current one, how could this be done?

Thanks in advance