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.