Differnce Between one date and another

[Fireguy5309]

Hi all,
Well once again I need a little help. I am trying to use a formula to tell me the number of days between one date and today. For example, I put 1 dec 05 in Cell A2 and I want cell B2 to tell me the number of days it has been since 1 Dec 05. Is there any formula that will do this for me?

Thanks well in advance for the help all, you have all been life savers here.


Fireguy

 

[just_jon]

If your 1 Dec is a true date -- as in 12/1/2005 -- then

=TODAY()-A2

EDIT Format as number.

 

[Fireguy5309]

Jon, Thank you once again, I can not tell you how much this board has helped me out.

Fireguy

 

[mdusoe]

=A2-DATE(2005,12,1)

Try this one... You will need be sure that B2 is formatted as number. It will default to Date.

HTH,
Mike.

 

[just_jon]

Jon, Thank you once again, I can not tell you how much this board has helped me out.

Fireguy

No problem.

Have a Kirin on us!

 

[Fireguy5309]

Mike,
Thank you also for the excellent idea. I usually use dates formatted as such, 1 DEC 05 since that is how I learned to do it for the military 20+ years ago. I am sure I will be able to use your suggestion in another project down the line.

Randy