** HELP ** Need help to calculate workdays between two dates

[sruk89]

Hi All,

I need help with calculating work days between two dates in Column/Cell AP8 I have a formula "=Today()" and in column/cell E8 I have a date which will return a date of when a migration is due to take place. The issue i have is that the formula in column/cell AH8 calculates total days between todays date and the migration date, I need it to calculate work days only.

Any help greatly appreciated.

Regards,

Scott

[#2 · Accepted solution]

The function you need is NETWORKDAYS

[#3]

i am trying to calculate the days between two dates in excel and it is not working. I do not have DATEDIF and the other alternatives are not working for me.  When I use DAYS, the answer comes up in a date format.

Please help.

[#4]

@BettyAnderson23 

DATEDIF doesn't show up in the function list when you start typing a formula. That's true, and due to that it is not an official Excel function. Look in the link below for more information.

DATEDIF function - Microsoft Support

[#5]

@BettyAnderson23 

Difference in days between two dates is like =B1-A1 assuming such dates are in B1 and A1