View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Steve Steve is offline
external usenet poster
 
Posts: 97
Default Date Calculation

I've tried the =networkdays(A1,A2) function, formatted the cell as a number
but it keeps coming up with #NAME?

TIA
Steve



"Niek Otten" wrote in message
...
Hi Steve,

Look in HELP for the NETWORKDAYS() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Steve" wrote in message
ups.com...
| Hi
|
| Anyone know how I can calculate the amount of days between two dates
| not
| taking into account weekends and possible Bank holidays?
|
| TIA
| Steve
|