date subtraction

  • Thread starter geert.van.ransbeeck
  • Start date
G

geert.van.ransbeeck

Hi

I have to subtract 2 dates ans become a rsulte as ex. 5.3 years.
So now I have a formula here which doesn't take into account the exact
starting & ending days.
formula: Period: Year([Enddate_of_Loan])-Year(Now())
Can somebody help me with a formula which is more precise and gives me
a result upon 2 decimals?

thanks in advance
geert
 
M

Marshall Barton

I have to subtract 2 dates ans become a rsulte as ex. 5.3 years.
So now I have a formula here which doesn't take into account the exact
starting & ending days.
formula: Period: Year([Enddate_of_Loan])-Year(Now())
Can somebody help me with a formula which is more precise and gives me
a result upon 2 decimals?
Click to expand...


If leap years are insignificant, try using:

DateDiff("d", Date(), [Enddate_of_Loan]) / 365

Format the text box used to display the result to two
places.
 
Top