Forum Discussion
sruk89
Sep 19, 2023Copper Contributor
** 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...
- Sep 19, 2023
The function you need is NETWORKDAYS
BettyAnderson23
Sep 16, 2024Copper Contributor
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.
- Riny_van_EekelenSep 16, 2024Platinum Contributor
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.
- SergeiBaklanSep 16, 2024MVP
Difference in days between two dates is like =B1-A1 assuming such dates are in B1 and A1