Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Start_date End_date Number of Months
01-12-2014 01-06-2015 ???
Hey guys from the table above, how can I calculate the number of month between those dates. Any help will be truly appreciated.
Thanks.
Like this..
=Year(Date#('01-06-2015','DD-MM-YYYY'))*12 + Month(Date#('01-06-2015','DD-MM-YYYY')) - (Year(Date#('01-12-2014','DD-MM-YYYY'))*12 + Month(Date#('01-12-2014','DD-MM-YYYY')))
Same exact expressions as Manish, but I thought this will be a good link to see:
You may use this
=Month(Date#(Start_date,'DD-MM-YYYY')) - Month(Date#(End_date,'DD-MM-YYYY'))
OR Simple this
=Month(Start_date) - Month(End_date)
hi
I think this will help's You..
Round((Date(EndDate)-Date(StartDate))/30) & ' | Months' |
Thanks Manish for your help