Probably been asked a million times but really struggling to find the right answer. I need to count the workdays since a specific date but need it to update on the day it opens. For example in A1 I type the activity as started on 1 Dec 20 and so in A2 it would say 8 (working days) when I open it today. When I open the doc on Monday it would say 9, Tues 10 and so on.
Column A1 is where the dates would sit but some may be blank until a date is entered so the formula would need to be able to cope with an empty field.
Hope I'm making sense, can always screenshot the spreadsheet if that helps.
Column A1 is where the dates would sit but some may be blank until a date is entered so the formula would need to be able to cope with an empty field.
Hope I'm making sense, can always screenshot the spreadsheet if that helps.