I’m having issues with trying to calculate the number of workdays between two dates: Work Stoppage Start and NOW formula [for the following examples, NOW is using today’s date: 12/15].
I have two columns: Days [formula att.] & Work Stoppage Start [date att.]
Originally, I was only counting total days, not just workdays. The formula I used was working perfectly fine.
DAYS(NOW(),Work Stoppage Start):
However, to provide a better look at how many days we were actually affected by the work stoppage, I decided to use NETWORKDAYS formula, instead of DAYS:
NETWORKDAYS(NOW(), Work Stoppage Start):
Obviously, that was not the solution. Then, I noticed that technically, the start date and end date were switched. So I switched them:
NETWORKDAYS(Work Stoppage Start, NOW()):
Well, that wasn’t right either! There’s 1 day between 12/14/2021 and 12/15/2021 (today), not 3.
Out of curiosity only, I wondered what the DAYS formula would do if the start date and end date were also switched like the above:
DAYS(Work Stoppage Start, NOW()):
Am I doing something wrong? Please don’t tell me I have to make ANOTHER column with only the NOW formula.