Yes and No Formulas

[spber68]

Hello,

I need a formula that will give me a yes or no for orders that were placed within the last 90 days and then have a Y or N in the column next to the last order date column(below). Is there a formula that will work? Thank you for your assistance as I haven't used Excel in quite some time and I need help.

Last Order Date Last 90 Days
06/22/2017
06/22/2017
06/22/2017
06/22/2017
06/22/2017
06/22/2017
06/22/2017
06/22/2017
06/22/2017

[oeldere]

You get better help on your question if you add a small excel file, without confidential information.

Please also add manualy the expected result in your file.

To Attach a File:

1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[Logit]

.
If you are matching against the 'Last Order Date' column ... this should work. (If you are wanting to check ALL columns, this won't work):

Please Login or Register  to view this content.

Note: The above presumes your Last Order Date column is "A" and the code is pasted in "B"

Last Order Date Last 90 Days
2/22/2017
8/22/2017	YES
6/22/2017
8/6/2017	YES
6/22/2017
8/22/2017	YES
6/22/2017
6/22/2017
6/22/2017

[leelnich]

On row 2:

Please Login or Register  to view this content.

[Logit]

.
Disregard my answer. leelnich is correct.

My mind read 90 days but "saw" 30 days. My apologies.