From a Specific day until Today

  • Thread starter Thread starter That's Confidential
  • Start date Start date
T

That's Confidential

Is there anyway I can enter a formula, whereby I enter a date and minus that
date from today's date to give me the number of days (including weekends,
holidays etc....)

Say for example =TODAY()-12/02/2004 = 64

If that makes sense!

Any ideas?
 
Hi
If your date is in A1 then use

=TODAY()-A

Excel will probably try to display this number in a date format, so you will need to set the number format to "number" after you enter the formula

Another function would be

=DATEDIF(A1,TODAY(),"d"

This has a number of other formats which you can find at

http://www.cpearson.com/excel/datedif.ht

Good Luck
Mark Graesse
(e-mail address removed)
Boston M

----- That's Confidential wrote: ----

Is there anyway I can enter a formula, whereby I enter a date and minus tha
date from today's date to give me the number of days (including weekends
holidays etc....

Say for example =TODAY()-12/02/2004 = 6

If that makes sense

Any ideas
 
Back
Top