Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: beginner has a question

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Midwest, USA
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,599
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    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

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Georgia USA
    Posts
    569
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #4
    New Member
    Join Date
    Feb 2002
    Location
    Midwest, USA
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #5
    New Member
    Join Date
    Feb 2002
    Location
    Midwest, USA
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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