Try this...

=TODAY()-D5

--
Biff
Microsoft Excel MVP


"Sunshine" wrote in message
...
in cell D5 I have the date 2/12/10...in cell D6 is blank but is assumed to
be
today's date...in cell D7 I need it to calculate the number of days from
2/12
to today.