Counting workdays to the present day

[Sambrowne]

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.

 

[Fluff]

How about

=if(L3="","",NETWORKDAYS(L3,IF(N3="",TODAY(),N3)))

 

[Sambrowne]

@Fluff That's brilliant - thanks!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Dave Patton]

I didn't see reply.

 

[Sambrowne]

Another follow on question if I may. I want to count the years and months to the present day from a specific date and same deal as above, updates every time I open it. For example, in my current book I have the date 29 Aug 19 in H5 and in I5 I want it to show how many years and months from that date to today and so on.

 

[Fluff]

As this is a different question you will need to start a new thread. Thanks