From a Specific day until Today

[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?

 

[Chip Pearson]

Try

=TODAY()-DATE(year,month,day)



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Mark Graesser]

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

 

[Frank Kabel]

Hi
try
=TODAY()-DATE(2004,2,12)

 

[That's Confidential]

Perfect Chip!

Thanks

Try

=TODAY()-DATE(year,month,day)



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com