How to calculate number of calender days

Solved/Closed
headache - May 12, 2011 at 08:48 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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