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
|