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.

Solved: Excel Dates

Discussion in 'Business Applications' started by Dreambringer, Nov 1, 2005.

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

    Dreambringer Thread Starter

    Joined:
    Jan 19, 2005
    Messages:
    1,351
    Quick question.

    Lets say I have a date.

    11/01

    Is there a formula that would return and IF statement?

    For example

    I am looking to all the dates between 12/15 and 01/15

    I have tried to create a formula using the IF statement, but cant only get the first half.

    =IF(A1<=12/15,"TRUE","FALSE")

    But how do I get the second half for it to check if if the date is less then 01/15? every time I try I get an error.
     
  2. exegete

    exegete

    Joined:
    Oct 26, 2005
    Messages:
    354
    Howdy. If I understand correctly. Be sure to check year, since the year will be in the cell whether it displays or not.

    =IF(AND(A1<=12/15,A1>01/15),"TRUE","FALSE")
     
  3. maxflia10

    maxflia10

    Joined:
    Feb 24, 2003
    Messages:
    331
    Try coercing the date and use a nest IF/AND,

    =IF(AND(A1>"12/15/2004"+0,A1<"1/15/2005"+0),If True,If False)

    Change the dates etc to suit your needs.
     
  4. Dreambringer

    Dreambringer Thread Starter

    Joined:
    Jan 19, 2005
    Messages:
    1,351
    got it! :) thank alot guys :)
     
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/412965

  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