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

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
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
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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)
 
Upvote 0

Forum statistics

Threads
1,213,487
Messages
6,113,938
Members
448,534
Latest member
benefuexx

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
Back
Top