srizki
Well-known Member
- Joined
- Jan 14, 2003
- Messages
- 1,844
- Office Version
- 365
- Platform
- Windows
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
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