Forum Discussion
Solved
Formula with Multiple Date Ranges
I need to figure out a formula for when a date within a certain range is entered in one cell, a certain character is produced in another cell. Example: I want for the date range of 10/19/2020 - ...
Hi there,
Actually, my formula is also for one cell result oriented. Just , it has been written in three rows in my previous response message box.
Hi there,
I hope the following formula will help you to solve this issue:
=IF(AND(A2>=DATE(2020,10,19), B2<=DATE(2020,10,25)), 11, IF(AND(A2>=DATE(2020,10,26), B2<=DATE(2020,11,1)), 18, IF(AND(A2>=DATE(2020,11,2), B2<=DATE(2020,11,8)),25,"")))
Cell A - beginning date of range where Cell B shows ending date of date range.
Please note attached file for your further consideration.
If you consider this response your best one, please note.
Good luck.