If statements to check range for dates within current month, week and quarterly.

[trying-my-best]

Playing around with this I'm struggling to figure out how to do this. I want to have an IF formula to check if Column A has any dates within the past week (month, or quarter) depending on which it's checking, for the respective tasks in column B to column F. And, if TIME is not blank, giving it a checkmark. Much like I have in the daily tasks, but these tasks only need completed weekly or monthly, and quarterly. I haven't been able to figure out how to do this. I don't want the last 7 days, 30 days, or 90 days because I want it to reference the current week or the current month.

Please see attachment. Thank you for your help.

**My apologies - my first upload of attachments didn't have the correct formula in the DAILY fields. That has been corrected now.

question1a.png

[AliGW]

Sorry - I don't get what you are after. Where in the file are your expected outcomes, mocked up manually? All the dates are today, so ...

[trying-my-best]

FYI, I just uploaded the updated Screenshot and excel doc.

It's the mockup - so the dates are all for today, yes. But, I guess you're right. A date will likely need to be changed to a previous one for this purpose.

So, the I column will have the respective formulas. When a time is entered into C, I want there to be a checkmark in the respective I cell so until it's no longer within range of the G column. This lets user know they now need to complete this task.

Does that clarify?

[AliGW]

No - I have already looked at the screenshot and workbook.

Please provide a sample workbook that reflects the set-up you are describing AND has manually entered results to demonstrate what you want.

[trying-my-best]

How do these work to help clarify?

Thank you for your help.

question1b.png