View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default how to count number of days between 2 dates?

You have to install the analysis toolpak.

Tools|Addins|check Analysis Toolpak

If it's not listed there, you'll have to install it from the Office CD.

doyree wrote:

please help!!

A B
01/28/08 02/03/08

i have two dates shown above in dates format and i would like to count the
days between those dates.

i tried
=NETWORKDAYS(B2,A2) but got #NAME?

can someone please help?

thank you!


--

Dave Peterson