Dec 08 2022 01:56 AM
Hi all,
I want to set up an formula as follow:
If value is >3, then startyear can't be later than 25% from the cyclus from begin inspectiondate
So
=IF(A2>3; then cyclus (column N) = 15years *0,25=3,75 years
Inspection data (column DC) = 01-01-1900 + 3,75 years = 30-09-1904
Startyear in dataset (column L) = 2037
Value 1904 < then 2037 so True
I hope somebody can help me
Thanks in advance :)
Dec 09 2022 07:54 AM
Maybe you can use EDAT().
=EDATE("1900-01-01",(3.75*12))
However, the result is "1903-10-01" depending on your formatting of the cell.