IF/OR Formula

[formulaquestion]

I am trying to get a formula that reads the last cell of a column that has any information, and to identify that value as "complete" if the day is today-2 OR today-1.

=IF(LOOKUP(2,1/(D:D<>""),D:D)=TODAY()-2,"completed") works fine. When I try =IF(OR((LOOKUP(2,1/(D:D<>""),D:D)=TODAY()-1),(LOOKUP(2,1/(D:D<>""),D:D)=TODAY()-2),"completed")) it does not work. Could someone please advise how I can get this formula working or if there is a better way to do this?

Thanks!

[63falcondude]

Hello and welcome to the forum.

Instead of sharing a non-working formula, please upload a small representative sample of your data along with the desired output of the formula (manually entered).

To upload a workbook, click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[daddylonglegs]

Looks like you have a parenthesis wrongly placed - try this

=IF(OR(LOOKUP(2,1/(D:D<>""),D:D)=TODAY()-1,LOOKUP(2,1/(D:D<>""),D:D)=TODAY()-2),”Completed”)

Or shorter

=IF(OR(LOOKUP(2,1/(D:D<>""),D:D)=TODAY()-{1,2}),”Completed”)

[formulaquestion]

@63falcondude, thanks for the welcome! I cannot upload anything at this time, but basically all of column D is a string of dates (10/1/2017, 10/3/2017, etc) starting from cell D7 down.

@daddylonglegs, thank you for the quick response! Unfortunately, those formulas are not working out for me. I am getting the #NAME? error. I have been wondering if the better solution would be to do something like TODAY is greater than -2, but am not sure how to phrase it formula-wise.

[63falcondude]

Perhaps the NAME error is due to the quotes.

Change ” to ".

[formulaquestion]

That was totally it! Thank you both so much! This helped a lot!

[63falcondude]

I didn't do much but I'm glad that we could help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[daddylonglegs]

Perhaps the NAME error is due to the quotes.

Change ” to ".

Thanks falcondude - I’m on my iPad and it’s definitely punctuactionally challenged

[63falcondude]

Happy to assist. Happens if you write out a formula in Word too.