Differnce Between one date and another

Fireguy5309

Board Regular
Joined
Dec 12, 2005
Messages
81
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
 

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473
If your 1 Dec is a true date -- as in 12/1/2005 -- then

=TODAY()-A2

EDIT Format as number.
 

Fireguy5309

Board Regular
Joined
Dec 12, 2005
Messages
81
Jon, Thank you once again, I can not tell you how much this board has helped me out.

Fireguy
 

mdusoe

Active Member
Joined
Aug 27, 2004
Messages
428
=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

Legend
Joined
Sep 3, 2002
Messages
10,473
Fireguy5309 said:
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

Board Regular
Joined
Dec 12, 2005
Messages
81
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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,534
Messages
5,572,743
Members
412,482
Latest member
arooshrana2
Top