Hi, I'm trying to create a total days column based on the following:
start date - end date (ie., 10 days)
1/1/21 - 1/10/21
end date changes to new end date based on extension 1 (i.e., 20 days)
1/1/21 - extended to 1/20/21
extensions can happen at least 4 times (columns are TA EXT 1, TA EXT 2, TA EXT 3 (all are date fields)
Also, a cancellation an impact the total on any of the end dates
so, my total from the above should be 20
if a cancellation happens 1/19/21, the total days number should reflect 19
I think i need a formula that looks first at the start date and end date then if the cancellation field is blank, looks for the extensions - if those are blank, it is end date - start date; if they are not blank, it needs to calculate the days extended... help!
Help Article Resources
Check out the Formula Handbook template!