Formula to create working days including sat and sun???

[sandeepprasad_j]

Hello Experts,

Is there any function or formula to calculate the working days including sat and sun...

Thanks a ton in advance.

Sandeep.

[jagan · Accepted solution]

Hi, 

Try Interval() for getting the difference between 2 dates if Saturday and Sunday are working days.

=Interval(EndDate - StartDate, 'd')

If Saturday and Sunday are not working days then use NetWorkDays().

Hope this helps you.

Regards,

Jagan.

[sandeepprasad_j]

Thanks so much Jagan...

Sandeep.