Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to figure out the date difference between two dates but the value displayed as a whole number(years) and decimal(months). I can do Year(Formula) to get a whole number but my requirement is to display the value to the .00.
StartDate = 2013-12-18
Ex: (Today()- (StartDate)) = 5.5
I have read through the community but all of the proposed solutions have not worked for me. Any help or direction is greatly appreciated.
Thanks,
Phil
Can you do:
(EndDate - StartDate) / 365
-Rob