Forum Discussion
** HELP ** Need help to calculate workdays between two dates
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
The function you need is NETWORKDAYS
The function you need is NETWORKDAYS
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.
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.
Difference in days between two dates is like =B1-A1 assuming such dates are in B1 and A1
