Count number of days

Ben2k

Board Regular
Joined
Oct 16, 2002
Messages
77
If I have a cell with a date in, how can I display the number of days which have passed between that date and the present (todays) date. Can it be done??
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

IML

MrExcel MVP
Joined
Feb 15, 2002
Messages
1,743
On 2002-10-17 12:34, Ben2k wrote:
If I have a cell with a date in, how can I display the number of days which have passed between that date and the present (todays) date. Can it be done??

You could use
=-A1+TODAY()

with a date in a1
 

IML

MrExcel MVP
Joined
Feb 15, 2002
Messages
1,743

ADVERTISEMENT

On 2002-10-17 12:36, Mark W. wrote:
=TODAY()-A2

where A2 contains your date.

Mark,
Our posts crossed in the mail (twice, now), but I thought you'd be interested in the one I suggested - it seems to retain the general format as I've seen you suggest on similiar date posts in the past.
This message was edited by IML on 2002-10-17 12:42
 

manney

New Member
Joined
Mar 25, 2002
Messages
46
An easy way is the formula (assuming the date is in A1)

=Today()-A1

The cell containing this formula must be formatted as General. This formula may then be copied and pasted down a column.

The number of days will increase as time goes on, as =Today() returns the current date. An easy way of entering today's date in a cell-- so it stays permanently-- is CTRL+; (Control key + semicolon). The two dates may then be subtracted.

P Manney
 

Mark W.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654
On 2002-10-17 12:41, IML wrote:

Mark,
Our posts crossed in the mail (twice, now), but I thought you'd be interested in the one I suggested - it seems to retain the general format as I've seen you suggest on similiar date posts in the past.

IML on 2002-10-17 12:42 ]</font>

Ahhh... This formulation also works for that purpose...

=(TODAY()-A2)
 

Forum statistics

Threads
1,144,358
Messages
5,723,889
Members
422,524
Latest member
wirkkarn

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top