+ Reply to Thread
Results 1 to 8 of 8

Determine status based on today's date (how to write the IF formula?)

  1. #1
    Registered User
    Join Date
    01-14-2018
    Location
    Australia
    MS-Off Ver
    Office 2017
    Posts
    3

    Determine status based on today's date (how to write the IF formula?)

    Hi,

    Just need some quick help with an IF function

    Capture.JPG

    I want to populate the status column with the following results

    DUE, Current or Forecast

    DUE if B=Drawn and the date returned <=TODAY+30
    Current if B=Drawn and the date returned >=TODAY+31
    Forecast if B=Forecast

    Any help greatly appreciated.

    Cheers

    Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good titles. I have updated it for you this time because you are a new member. --6StringJazzer
    Last edited by 6StringJazzer; 01-14-2018 at 10:25 PM.

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Determine status based on today's date (how to write the IF formula?)

    Welcome to the board.

    This is assuming B can only be Drawn or Forecast, i.e., if it's not Forecast, it therefor must be Drawn.

    =IF(B4="Forecast",B4,IF(C4>=TODAY()+31,"Current","Due"))

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Determine status based on today's date (how to write the IF formula?)

    In D4:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    If column B contains anything besides Drawn or Forecast you will get weird results.

    In the future please bear in mind that an image attachment has very little value. Just attach the Excel file. It's easier than taking a screenshot first and then attaching that. The paper clip icon does not work for attachments. Instead, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  4. #4
    Registered User
    Join Date
    01-14-2018
    Location
    Australia
    MS-Off Ver
    Office 2017
    Posts
    3

    Re: Determine status based on today's date (how to write the IF formula?)

    Thanks....If I was to throw cancelled in as a possible alternative to Forecast and Drawn, how would I go about that?

  5. #5
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Determine status based on today's date (how to write the IF formula?)

    You need to give more details, what should happen if it's cancelled?

  6. #6
    Registered User
    Join Date
    01-14-2018
    Location
    Australia
    MS-Off Ver
    Office 2017
    Posts
    3

    Re: Determine status based on today's date (how to write the IF formula?)

    IF B= Cancelled then D=Cancelled

  7. #7
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Determine status based on today's date (how to write the IF formula?)

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  8. #8
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Determine status based on today's date (how to write the IF formula?)

    =IF(B4="Drawn",IF(C4<=TODAY()+30,"DUE","Current"),IF(B4="Forecast","Forecast",IF(B4="Cancelled","Cancelled")))
    Again following the assumption that B can only be Drawn Forecast or Cancelled

    Try
    =IF(B4="Drawn",IF(C4<=TODAY()+30,"DUE","Current"),B4)

+ 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. Simple (?) chart prob--Needing a simple solution!
    By baloo308 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-06-2016, 12:24 PM
  2. Replies: 4
    Last Post: 12-07-2012, 11:49 AM
  3. A simple question requiring a simple answer
    By Pedros in forum Excel General
    Replies: 3
    Last Post: 07-18-2006, 06:45 AM
  4. Simple Simple Excel usage question
    By BookerW in forum Excel General
    Replies: 1
    Last Post: 06-23-2005, 05:05 PM
  5. [SOLVED] Make it more simple or intuitive to do simple things
    By Vernie in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-16-2005, 12:06 AM
  6. Posting data from a simple form to a simple database
    By clacka in forum Excel General
    Replies: 0
    Last Post: 01-30-2005, 04:37 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