Forum Discussion
Counting days
Hi team Hoping you can assist with a tricky one. I am counting the number of days between when a job is received, to when it is completed. I have been using TODAY() as the end date which gives me ...
Andy1883 Well, the basic structure of such a formula would be:
=IF(
ISBLANK(G...),
DAYS(end_date, start_date),
DAYS(TODAY(),start_date)
)
Obviously, replace G... with a reference to "Total Distance (m)" and start_date to "Approval Date". That leaves us with determining the end_date. I see no column for it in your table so you would have to insert one where you can enter it as soon as column G gets entered. But then you can also directly refer to that column, of course, when you check if a job is complete.