1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel Help - Date Formulas

Discussion in 'Business Applications' started by scotepsu22, Oct 15, 2008.

Thread Status:
Not open for further replies.
Advertisement
  1. scotepsu22

    scotepsu22 Thread Starter

    Joined:
    Oct 15, 2008
    Messages:
    1
    Using Excel from Office 2007, I am trying to figure out the correct formula to add a number contained within a cell (if) the date contained within one cell is later than the date contained in another cell.

    Any help would be greatly appreciated!!!
     
  2. computerman29642

    computerman29642

    Joined:
    Dec 4, 2007
    Messages:
    2,895
    scotepsu22, welcome to the forum. :)

    So, what you are trying to do is have a formula that will insert a certain number in a cell if one date is older/later than the other? What number are you trying to enter?

    Can you attach a sample file with dummy data?
     
  3. computerman29642

    computerman29642

    Joined:
    Dec 4, 2007
    Messages:
    2,895
    Are you trying to find the number of days between the two dates?
     
  4. edhicks

    edhicks

    Joined:
    Jun 30, 2008
    Messages:
    248
    welcome to this forum

    The attached file is an attempt to answer your question as I understand it.
    Check it out and advise if any problems
    Good Luck :D
     

    Attached Files:

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/759440

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice