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 Edgar, thank you for your response.
I am actually trying to get a formula for one cell only.
The formula I currently have for the cell is:
=IF(AND($BK$4>=DATEVALUE("10/19/2020"),$BK$4<=DATEVALUE("10/25/2020")),"11","")
This formula populates "11" when someone enters a date between the date range 10/19 - 10/25.
Now I need to make it so that the cell will also populate a different number, when a date in a different range is entered.
Example:
A date entered between 10/19/20 - 10/25/20 will populate 11
A date entered between 10/26/20 - 11/01/20 will populate 18
A date entered between 11/02/20 - 11/08/20 will populate 26
I am needing code for all of this for the same cell.
I have attached my document with the 2 cells I am working with highlighted in Green.
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 Sir Ilgar_Zarbaliyev , can you help me, please? I just need the formula to identify the applicable fees (Column D) and cross-check whether the charged fees vs the applicable fee (based on the "Fees" tab) is correct, but there are multiple dates to consider. Can you help me, please?
Thanks a lot!
https://docs.google.com/spreadsheets/d/1V1j6D06caZXHaVZOoRSPBsLmp6hglE3x/edit?usp=sharing&ouid=106089949912200570919&rtpof=true&sd=trueThe layout of the Fees sheet is not handy, I changed it in the attached version.
HansVogelaar Wow, thanks a lot! I already updated the rest of my file. Thanks again for the help.
You are right this works!
Trying it with DATEVALUE doesn't work but it works with DATE.
Thank you!
- Here you are!
Hai Sir kindly help me on this excel range formula:
If date in column A is in between date in 2/3/2022 - 3/8/2022 answer in column B will be Chair
If date in column A is in between date in 4/8/2022 - 9/12/2022 answer in column B will be Table
If date in column A is in between date in 10/12/2022 - 4/4/2023 answer in column B will be Glue
I hope sir can help me on create the formula. Thanks
