# Counting workdays to the present day

#### Sambrowne

##### New Member
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

##### MrExcel MVP, Moderator
Excel Formula:
``=if(L3="","",NETWORKDAYS(L3,IF(N3="",TODAY(),N3)))``

### Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

#### Sambrowne

##### New Member
@Fluff That's brilliant - thanks!

#### Fluff

##### MrExcel MVP, Moderator
You're welcome & thanks for the feedback.

#### Sambrowne

##### New Member
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

##### MrExcel MVP, Moderator
As this is a different question you will need to start a new thread. Thanks

Replies
6
Views
439
Replies
1
Views
185
Replies
3
Views
73
Replies
2
Views
175
Replies
0
Views
213

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,152,483
Messages
5,770,361
Members
425,612
Latest member
martinijr

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back