substitute plan date with actual date
Trying to create a formula that can substitute the plan date with actual date.
There are columns of Plan Start/End, Actual Start/End on the sheet, and the actual start & end are initially left blank, and once a task is kicked off, the one assigned is supposed to fill in the actual start, which substitutes the planned start and we can see if the plan end will be pulling or put off. Same principle goes to end date: When a task is finished, that is the actual end date be filled, the plan end date will be substituted and same as the actual end.
Thank you for your help.
Help Article Resources
Check out the Formula Handbook template!