Thread: [Solved] Calculate due date with variable based on different start dates.
View Single Post
 
Old 04-24-2024, 09:38 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2021
Expert
  
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
Code:
=IF([@[POP End Date]]="","",[@[POP End Date]]-IF([@[Declaration Date]]<=DATE(2023,3,22),60,90))
Reply With Quote