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.

     

     

     

Ilgar_Zarbaliyev's avatar
Ilgar_Zarbaliyev
MCT
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.

 

 

 

ZanneVA's avatar
ZanneVA
Copper Contributor
May 29, 2023

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=true