Calculating a due date based on two different starting points.

[wsnow]

I have this formula:

=IF(ISBLANK([@[Declaration Date]]),"",[@[Declaration Date]]+IF([@[Declaration Date]]<DATE(2024,8,15),365,457))



It reads a declaration date, and then returns an application due date either 365 or 457 days out from declaration date, depending on whether the declaration date was before or after 8/15/2024.

I would prefer to have it add 12 or 15 months to the Declaration Date rather than 365 or 549 days but don't know how to do that. And I don't really know how Excel knows that the 365 and 549 in the formula indicates days instead of months, or years.

Thanks in advance...

[Pecoflyer]

Perhaps

=IF(ISBLANK([@[Declaration Date]]),"",IF([@[Declaration Date]]<DATE(2024,8,15),EDATE([@[Declaration Date]],12),EDATE(,[@[Declaration Date]],15))

[wsnow]

The formula sure looked right to me, but Excel tells me it has "too many arguments".

[Pecoflyer]

From my suggestion,remove the comma after the second "EDATE(" (sorry for the typo)

=IF(ISBLANK([@[Declaration Date]]),"",IF([@[Declaration Date]]<DATE(2024,8,15),EDATE([@[Declaration Date]],12),EDATE([@[Declaration Date]],15))

[wsnow]

Thanks! I missed that as well, obviously...

[Pecoflyer]

Deleted by author