Counting workdays to the present day

Sambrowne

New Member
Joined
Sep 13, 2016
Messages
24
Office Version
  1. 365
Platform
  1. MacOS
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
Joined
Jun 12, 2014
Messages
68,280
Office Version
  1. 365
Platform
  1. Windows
How about
Excel Formula:
=if(L3="","",NETWORKDAYS(L3,IF(N3="",TODAY(),N3)))
 
Solution

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.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
68,280
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback.
 

Sambrowne

New Member
Joined
Sep 13, 2016
Messages
24
Office Version
  1. 365
Platform
  1. MacOS
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
Joined
Jun 12, 2014
Messages
68,280
Office Version
  1. 365
Platform
  1. Windows
As this is a different question you will need to start a new thread. Thanks
 
Master Excel Bundle

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.

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top