Hi There,
I’m using the following formula to calculate how many days late an item is, however, I would like to add in an If statement, that uses today’s date, if the Actual Finish Date cell is blank - does anyone know how to do this?
DAYS({Actual Finish Date},{Timeline#End})
Many thanks,
Jenny
@JennyA
‘DAYS(IF({Actual Finish Date},{Actual Finish Date},TODAY()),{Timeline#End})’
Jim - The Monday Man Column Magic - the magical columns toolbox app
Works like a dream, thank you
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
Column Magic 