![]() |
#6
|
||||
|
||||
![]()
Caholmes
your formula does not take the day into account but only months, therefore creating a result which might not be what the OP needs. Test it for March 31st and you will see that it returns 1 month, although it's less than one month. ( 19 days today) If one is only concerned about the number of months Code:
=DATEDIF(A1,today(),"m") But then again, as is common with dates, the OP did not specify what he wants exactly
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
calculation of start date | ketanco | Project | 1 | 02-29-2012 07:01 AM |
![]() |
danbl | Excel | 8 | 02-23-2012 04:35 AM |
![]() |
manich1 | Excel | 2 | 12-07-2011 02:59 PM |
![]() |
UnholySmoke | Excel | 2 | 09-14-2011 08:15 AM |
![]() |
Snvlsfoal | Excel | 1 | 08-11-2011 05:54 AM |