Formula - Date if a condition is true
I am trying to use the formula - Date field to calculate a date that is nine months in the future from a specific date. This part is easy... I've used AdjustMonth([Date Due], 9). But I only want a ...
Forum Discussion
sorry, My answer above was wrong.
IF(
[Short or long]="Short", null,
[Box is checked], [Extension Due Date] + Days(30),
[Due date] + Days(30))
IF(
[Short or long]="Short", null,
[Box is checked], [Extension Due Date] + Days(30),
[Due date] + Days(30))