You might try this (example for two months) ... just change the +2 to +3 for 90 days ...
Let ( [
d = ExpirationDate ;
r = Date ( Month ( d ) + 2 ; 20 ; Year ( d ) )
r - Position ( "71" ; DayOfWeek ( r ) ; 1 ; 1 )
)... corrected typo
Thanks LaRetta for the additional comment. I realized now that I also need for the date to recalculate if the 20th of the month falls on the weekend that it calculate to the Friday before. I had previously used this
date- Middle ("2000001"; Mod (Expiration Date - Date (1;3;1904);7)+1;1)
How can apply this formula to the one you provided? Thanks again
Well, my calc does that, Erika. The portion with Position() subtracts 1 day if the DayOfWeek is Saturday (7) and 2 days if Sunday (1).