Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
"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
|
|||
|
|||
"Steph in PA" wrote in message ... "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 answer! |
#5
|
|||
|
|||
As Andy said:
Format the result as Number. -- Vasant "Steph in PA" wrote in message ... "Steph in PA" wrote in message ... "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 answer! |
#6
|
|||
|
|||
"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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Excel not recognizing Dates properly. | Excel Discussion (Misc queries) | |||
How do I get Excell to sort dates that range from 1800 to 1900's | New Users to Excel | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
due dates | New Users to Excel |