How to calculate number of calender days

Solved/Closed
headache - May 12, 2011 at 08:48 AM
TrowaD
Posts
2888
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
August 16, 2022
- May 13, 2011 at 10:20 AM
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

TrowaD
Posts
2888
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
August 16, 2022
515
May 13, 2011 at 10:20 AM
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
0