View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default calculate number of days formula

That looks like a typo (missing S), try

=NETWORKDAYS(start_date,end_date,holidays)

Regards,
Peter T

"ozgrid.com" wrote in message
...
Use the NETWORKDAY Function.


--
Regards
Dave Hawley
www.ozgrid.com
"Ranae" wrote in message
...
hi,
Can someone please help me with a formula to calculate number of days,
excluding weekend days?

A1 B1 C1
Start date End date Total days (excluding weekend)