Forum Discussion

taylorcobaugh's avatar
taylorcobaugh
Copper Contributor
Oct 08, 2020

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 - ...
excel
Formulas and Functions
  • Ilgar_Zarbaliyev's avatar
    Ilgar_Zarbaliyev
    Oct 08, 2020

    taylorcobaugh 

     

    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.

     

     

     

Atira_Syafiqah_7393's avatar
Atira_Syafiqah_7393
Copper Contributor
Apr 17, 2023

Ilgar_Zarbaliyev 

 

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_Zarbaliyev's avatar
    Ilgar_Zarbaliyev
    Steel Contributor
    Apr 17, 2023

    Atira_Syafiqah_7393 

     

    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.

     

     

Resources