having another brain cramp.
If I have 2 date fields LEASE_START_DATE and LEASE_EXPIRY_DATE how can I find the percentage of the way through the lease
I know in excel the following works - =IF(C3="","",(DATEDIF(C3,TODAY(),"d")+1)/(DATEDIF(C3,D3,"d")+1)) - where C3 is Start and D3 is End Date
Some of the fields are blank.
examples
LEASE START DATE LEASE END DATE % Way Through Contract 2014-12-30 2019-12-29 127% 2016-06-16 2021-06-15 98% 2016-07-28 2022-01-27 87% 2016-06-29 2021-12-28 88% 2016-10-13 2022-04-12 83% 2016-12-14 2021-12-13 88%
Thanks for the help as always