=today()-A1
and format as general.

This is just doing a subtraction, so weekends will be included.

(To excel dates are just numbers that are nicely formatted.)

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

--

Dave Peterson