We have two cells with 'planned start' and 'planned end' dates. We also have two cells for 'actual/revised start date' and 'actual/revised end date'. These are designed to allow managers to enter the estimated start/end date of a milestone, and the revised start and end date when things slip.
The actual/revised end date cell has a formula displaying =MAX({Actual End Date / Revised End Date]) and I can update this cell in multiple sheets, but not in a report (because its a formula and automatically generating the content). This becomes an issue when trying to update this cell across a number of workspaces.
What is the purpose of the =MAX formula in this context and do we need it?
