Assuming there are no holidays, this will work =NETWORKDAYS(A1,TODAY())
See Help to learn how to allow for holidays
I assume you want workdays. =TODAY() - A1 will give total days
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Jimbo" wrote in message
...
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