beginner has a question
Eliminate Pivot Table Annoyances
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
    81,872
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 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...!

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
  •  

 

 
DMCA.com