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...

Perhaps

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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

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

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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

Deleted by author

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post