beginner has a question

sandy · Feb 26th, 2002, 04:56 AM

I'm totally fascinated by this site... and I'm really trying to understand these formula equations. I have a question, and figuring this is probably very easy to all of you here, however I'm unfortunately not getting it. Does anyone know what formula can I use to get the total days from two dates? I am using the format 02/25/02. example: 02/25/02 subtracted from 04/02/02 (equals: 36)

Aladin Akyurek · Feb 26th, 2002, 04:59 AM

Quote:

On 2002-02-26 03:56, sandy wrote:
I'm totally fascinated by this site... and I'm really trying to understand these formula equations. I have a question, and figuring this is probably very easy to all of you here, however I'm unfortunately not getting it. Does anyone know what formula can I use to get the total days from two dates? I am using the format 02/25/02. example: 02/25/02 subtracted from 04/02/02 (equals: 36)

Sandy,

You can add, substract, average, etc the dates as you would ordinary numbers: So,

=B1-A1

where B1 is a later date than A1, will produce the desired diff in days. You need to format the cell of this formula as General though.

Aladin

Paul B · Feb 26th, 2002, 05:22 AM

Sandy take a look at Chip's web site he has a lot of stuff about dates, and other things.
http://www.cpearson.com/excel/topic.htm

sandy · Feb 26th, 2002, 05:31 AM

Thank you! I kept getting a date in the cell instead of a number. It worked, like you stated, whenever I formatted the cell to general. That's what I was looking for! Thanks again!

sandy · Feb 26th, 2002, 05:33 AM

Thanks Paul! I'll keep this site handy for future references...!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 26th, 2002, 04:56 AM	#1
sandy New Member Join Date: Feb 2002 Location: Midwest, USA Posts: 24	I'm totally fascinated by this site... and I'm really trying to understand these formula equations. I have a question, and figuring this is probably very easy to all of you here, however I'm unfortunately not getting it. Does anyone know what formula can I use to get the total days from two dates? I am using the format 02/25/02. example: 02/25/02 subtracted from 04/02/02 (equals: 36)

Feb 26th, 2002, 05:22 AM	#3
Paul B Board Regular Join Date: Feb 2002 Location: Georgia USA Posts: 544	Sandy take a look at Chip's web site he has a lot of stuff about dates, and other things. http://www.cpearson.com/excel/topic.htm

Feb 26th, 2002, 05:31 AM	#4
sandy New Member Join Date: Feb 2002 Location: Midwest, USA Posts: 24	Thank you! I kept getting a date in the cell instead of a number. It worked, like you stated, whenever I formatted the cell to general. That's what I was looking for! Thanks again!

Feb 26th, 2002, 05:33 AM	#5
sandy New Member Join Date: Feb 2002 Location: Midwest, USA Posts: 24	Thanks Paul! I'll keep this site handy for future references...!