Remember Me?

#1
May 23rd 05, 07:50 PM
 Steph in PA Posts: n/a
Can you substract dates?

Hi, I have a column in my spreadsheet with various dates. The dates could be
just a day apart, or weeks apart. I would like to calculate the number of
days between any two adjacent dates in that column. (This is because I need
to use that number of days to calculate the average weight I lose per day,
and I do not always weigh myself each day.)

So is there a way to do this?

Thanks!

#2
May 23rd 05, 07:53 PM
 Andy B Posts: n/a

Hi

Yes you can subtract dates. They are just numbers in Excel. Format the
result as Number.

Andy.

"Steph in PA" wrote in message
...
Hi, I have a column in my spreadsheet with various dates. The dates could
be
just a day apart, or weeks apart. I would like to calculate the number of
days between any two adjacent dates in that column. (This is because I
need
to use that number of days to calculate the average weight I lose per day,
and I do not always weigh myself each day.)

So is there a way to do this?

Thanks!

#3
May 23rd 05, 08:00 PM
 Steph in PA Posts: n/a

"Andy B" wrote in message
...
Hi

Yes you can subtract dates. They are just numbers in Excel. Format the
result as Number.

Andy.

Thanks Andy, but I tried subtracting 5/12/05 from 5/23/05, and it came out
with 1/12/00!!! Not "12 days", which is the correct answer!

#4
May 23rd 05, 08:01 PM
 Steph in PA Posts: n/a

"Steph in PA" wrote in message
news
"Andy B" wrote in message
...
Hi

Yes you can subtract dates. They are just numbers in Excel. Format the
result as Number.

Andy.

Thanks Andy, but I tried subtracting 5/12/05 from 5/23/05, and it came out
with 1/12/00!!! Not "12 days", which is the correct answer!

That should be 5/11/05 from 5/23/05, but it still comes out with the wrong

#5
May 23rd 05, 08:03 PM
 Vasant Nanavati Posts: n/a

As Andy said:

Format the
result as Number.

--

Vasant

"Steph in PA" wrote in message
news

"Steph in PA" wrote in message
news
"Andy B" wrote in message
...
Hi

Yes you can subtract dates. They are just numbers in Excel. Format the
result as Number.

Andy.

Thanks Andy, but I tried subtracting 5/12/05 from 5/23/05, and it came

out
with 1/12/00!!! Not "12 days", which is the correct answer!

That should be 5/11/05 from 5/23/05, but it still comes out with the wrong

#6
May 23rd 05, 08:23 PM
 Steph in PA Posts: n/a

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
As Andy said:

Format the
result as Number.

Oh duh!! Thanks Vasant, and apologies to Andy!

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post leinad512 Excel Discussion (Misc queries) 1 April 20th 05 04:19 PM Dan Excel Discussion (Misc queries) 1 March 23rd 05 07:19 PM Smith295 New Users to Excel 1 February 22nd 05 06:20 PM dpl7579 Excel Discussion (Misc queries) 1 January 11th 05 08:43 PM Niki New Users to Excel 4 January 10th 05 04:11 PM

All times are GMT +1. The time now is 12:33 PM.