Forum Discussion

taylorcobaugh's avatar
taylorcobaugh
Copper Contributor
Oct 08, 2020
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 - ...
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.

     

     

     

amgomez512's avatar
amgomez512
Copper Contributor
Nov 21, 2023

Ilgar_Zarbaliyev 

Hello, 

 

Hoping you can help me. 

 

If date in cell L2 is in between date in 11/9/2023 - 1/4/2024 answer in cell M2 will be NY

If date in cell L2 is greater than 1/5/2024 answer in cell M2 will be OH

If date in cell L2 TBD or Blank answer in cell M2 will be blank

 

Would you be able to help create a formula for this? 

Resources