Forum Discussion
Solved
IF Statements on variable dates
Hi Everyone, The Question; I am looking for help in constructing an IF statement or another formula to auto-generate Expiry dates based on variable rules. A Little 'O Context; This information...
Does this do it?
I have converted to a table to keep the data and formulas in sync.
= MIN( EDATE([@[Inspection Date]], IF(today-[@[AntiFoul Application Date]] < 182, 6, 3)), [@[Antifoul Expiry]] )
Does this do it?
I have converted to a table to keep the data and formulas in sync.
= MIN(
EDATE([@[Inspection Date]], IF(today-[@[AntiFoul Application Date]] < 182, 6, 3)),
[@[Antifoul Expiry]] )