+ Reply to Thread
Results 1 to 5 of 5

HELP! IF statement containing DATES

  1. #1
    Registered User
    Join Date
    04-13-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    3

    HELP! IF statement containing DATES

    Hello everyone,

    I tried to look around to see if there were anything similar to the problem I am running across, but had no luck.

    So I have this formula I am trying to set up. IF a date is entered in LOI Sign Date then the number 1 is automatically inputted into Phase Column, and IF the date entered in Leasing IS GREATER than the date in LOI Sign Date Column, then the number 2 will be automatically placed in Phase column, and IF the date entered in Space Delivery IS GREATER than Lease Sign Date, then the number 3 and so on....

    Here is the sample:
    Capture.JPG

    Basically I am trying to make the IF formula, but I keep getting the error. I am new at this, and just trying to figure this out.

    I have came up with this formula

    =IF(C2>DATEVALUE("12/31/2012"),"1","", IF(D2>C2,"2") and I get an error.

    Please help

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Version 2211 (Build 15813.20002) Win 11 Home 64 Bit
    Posts
    22,084

    Re: HELP! IF statement containing DATES

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    Pictures are difficult to interpret the specific needs.

    View Pic
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    06-26-2013
    Location
    Makati
    MS-Off Ver
    Excel 2010
    Posts
    140

    Re: HELP! IF statement containing DATES

    Hi,

    @PI Try see attached file...

    Book3.xlsx

  4. #4
    Registered User
    Join Date
    04-13-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: HELP! IF statement containing DATES

    Got it! Thank you!

    Quote Originally Posted by alansidman View Post
    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.....

  5. #5
    Registered User
    Join Date
    04-13-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: HELP! IF statement containing DATES

    Awesome! This helped, and now I see why I was getting the error. Thank you very much.
    Quote Originally Posted by Jul Stev View Post
    Hi,

    @PI Try see attached file...

    Attachment 256244

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. IF STATEMENT and Dates
    By gballard in forum Excel General
    Replies: 6
    Last Post: 05-30-2012, 03:31 PM
  2. Help with if statement with dates
    By jmoore1197 in forum Excel General
    Replies: 4
    Last Post: 10-06-2009, 03:10 PM
  3. IF statement and dates
    By jacko311 in forum Excel General
    Replies: 2
    Last Post: 05-15-2009, 10:20 AM
  4. Dates and if statement
    By FSCGunslinger in forum Excel General
    Replies: 7
    Last Post: 02-12-2008, 08:39 AM
  5. IF statement with two dates
    By jbormann in forum Excel General
    Replies: 2
    Last Post: 07-18-2006, 12:32 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1