View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Count Number of Days after a Start Date

Hi,

It's what networkdays was designed for

=NETWORKDAYS(A1,TODAY(),Holidays)

Holidays is a named range of holiday dates and can be ommited.

Mike

"Jimbo" wrote:

I need a formula to calculate the number of days from a start date.

In cell A1 I have the date 5/6/2009, when I open the spreadsheet 3 days from
now I want to display the number 3 in cell B1. Is this something you would
use with NETWORKDAYS?

I would appreciate your help.
--
Jim