ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   NETWORKDAYS including Saturday and Sunday (https://www.excelbanter.com/excel-discussion-misc-queries/187630-networkdays-including-saturday-sunday.html)

Sherry

NETWORKDAYS including Saturday and Sunday
 
How do I calculate two dates that will include the weekends?
--
Sherry Vinturella

Bob Phillips

NETWORKDAYS including Saturday and Sunday
 
=A2-A1

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Sherry" wrote in message
...
How do I calculate two dates that will include the weekends?
--
Sherry Vinturella




Fred Smith[_4_]

NETWORKDAYS including Saturday and Sunday
 
Don't use Networkdays. Just use normal subtraction, as in:

=a2-a1

Regards,
Fred.

"Sherry" wrote in message
...
How do I calculate two dates that will include the weekends?
--
Sherry Vinturella




All times are GMT +1. The time now is 01:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com