How to calculate number of calender days

[Solved/Closed]
Report
-
Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
-
Hello,


I have tried out the NETWORKDAYS formula and it worked out just fine, please could you provide formula to include the weekends.

Many thanks

1 reply

Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
486
Hi Headache,

To include weekends simply subtract one date from the other. Just remember to format the cell as number to get the correct result.

Best regards,
Trowa