Thanks:  0
Likes:  0

# Thread: beginner has a question

1. 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)

2. 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.

3. 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

4. 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!

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

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•