Determine if date is within specific date range

[JansiJansi]

Yo. I want a formula that does the same thing as this:

=IF(AND(A1>=start,A1<=end),"x","")

Buuut, I want it to use the same functionality as this when it comes to determining the "date":

=AND(D3>=(TODAY()-90),D3<TODAY())

Basically, I have a client who wants to know when the last time they received in inventory is. It can't be a static date, but instead needs to be a date range based off of the date it's being run, because the report is gonna be run regularly.

They have a Last Received date. Using the Last Received date, I want to determine which receive date was received within the last 0-90 days, 91-180 days, 181-270 days, etc.

For example, this is the spreadsheet I'm developing:

Is this something I can do? Or would I have to use VBA to define a start and end date based on today's date and use the second formula posted above?

Thank you, everyone! Happy Friday!

 

[6StringJazzer]

Your formula is exactly what you want for the 0-90 days column. You just need to add the "x".

=IF(AND(D3>=(TODAY()-90),D3<TODAY()),"X","")

Similar for the other columns.

=IF(AND(D3>=(TODAY()-180),D3<(TODAY()-90)),"X","")

etc.