Is there a way for us to create this with our formulas in Monday.com?
Hello @gracemeyer Yes this can be done with monday formulas and your thinking is on the right track.
You can calculate variance by comparing the planned date for each phase with the actual completion date, then use a conditional formula to decide which planned date to use based on the Integration Phase. Instead of deeply nested IFs, using SWITCH usually makes this much easier to read and maintain.
The clean approach is to keep each planned date in its own Date column or mirror it from a key dates board, then reference those columns in the formula. That way you are not hard coding dates and it stays flexible as timelines change.
Formula and column basics
https://support.monday.com/hc/en-us/articles/360001235445-Formula-Column
Date and workday functions
https://support.monday.com/hc/en-us/articles/360002858339-Available-Formula-Functions
Connecting or mirroring planned dates
https://support.monday.com/hc/en-us/articles/360015614779-Connect-Boards-Column
https://support.monday.com/hc/en-us/articles/360015611319-Mirror-Column