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

1. ## 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

2. ## 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. ## Re: Determine status based on today's date (how to write the IF formula?)

In D4:

Formula:
`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.

4. ## 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. ## 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. ## Re: Determine status based on today's date (how to write the IF formula?)

IF B= Cancelled then D=Cancelled

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

Formula:
`Please Login or Register  to view this content.`

8. ## 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)

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

#### 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