Forum Discussion
taylorcobaugh
Oct 08, 2020Copper Contributor
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 - ...
- Oct 08, 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.
Ilgar_Zarbaliyev
Oct 08, 2020Steel Contributor
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.
taylorcobaugh
Oct 08, 2020Copper Contributor
You are right this works!
Trying it with DATEVALUE doesn't work but it works with DATE.
Thank you!
- Ilgar_ZarbaliyevOct 08, 2020Steel ContributorHere you are!
- Atira_Syafiqah_7393Apr 17, 2023Copper Contributor
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
- Ilgar_ZarbaliyevApr 17, 2023Steel Contributor
Please find solution below:
=IF(AND(A12>=DATE(2022, 3,2),A12<=DATE(2022, 8,3)), "Chair",IF(AND(A12>=DATE(2022, 8, 4), A12<=DATE(2022, 12, 9)),"Table",IF(AND(A12>=DATE(2022, 12, 10), A12<=DATE(2023, 4,4)), "Glue", "")))
Sample file is attached to this message.
I hope it will help you.