Date Formula

[Elizabeth]

I am looking for the formula that will take a date, and
total the number of days by the current date. For
example, if I put a date of 30 days ago in one cell,
another cell will say that the date was 30 days ago, and
than the next day I open up and the cell will than say it
was 31 days ago

 

[Bob Phillips]

Elizabeth,

Isn't as simple as

=TODAY()-A1

and formatted as general

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Mark Graesser]

Elizabeth

=TODAY()-A

Replace A1 for your date cell. Format as Number General. Excel will probably ayto-format the cell to a date style when you first enter the fomula

Good Luck
Mark Graesse
(e-mail address removed)

----- Elizabeth wrote: ----

I am looking for the formula that will take a date, and
total the number of days by the current date. For
example, if I put a date of 30 days ago in one cell,
another cell will say that the date was 30 days ago, and
than the next day I open up and the cell will than say it
was 31 days ag

 

[Chris R. Lee]

Elizabeth,

=TODAY()-A1

Replace A1 for your date cell. Format as Number General. Excel will

probably

"Probably" is part of the problem with this aspect of XL. The word means
that you don't really know what it will do...

Regards


ayto-format the cell to a date style when you first enter the fomula.