Date calculation

[srizki]

I have dates in two columns and I am trying to calculate number of months, that is not a problem, the problem is that when a month starts and finish in the same month DATEDIF gives zero, for example, starting dare 01/01/2009 ending date 01/31/2009.
How can I alter the formula to get one month of fraction of a month if there are less days than a full month.

Thanks

 

[rconverse]

Add an if statement. =if(datedif=0, (date1-date2)/30, datedif)

it won't be exact. Especially in February, but it's going to be close. I guess it depends how accurate you need it. If you're measuring in months would .13 months really throw a wrench into things if were really .15?

HTH
Roger

 

[srizki]

Thanks Roger