Formulas IF , then

Occasional Visitor

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



=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  

1 Reply


Maybe you can use EDAT().


However, the result is "1903-10-01" depending on your formatting of the cell.