Formula for using today as date, when date column is bank in Duration calculation

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,



‘DAYS(IF({Actual Finish Date},{Actual Finish Date},TODAY()),{Timeline#End})’

Jim - The Monday Man
:magic_wand: Column Magic :sparkles:- the magical columns toolbox app

1 Like

Works like a dream, thank you

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.