OiO.lk Community platform!

Oio.lk is an excellent forum for developers, providing a wide range of resources, discussions, and support for those in the developer community. Join oio.lk today to connect with like-minded professionals, share insights, and stay updated on the latest trends and technologies in the development field.
  You need to log in or register to access the solved answers to this problem.
  • You have reached the maximum number of guest views allowed
  • Please register below to remove this limitation

Google Sheets - formula to return date value based on range of dates on another page

  • Thread starter Thread starter Mary Nottingham
  • Start date Start date

Mary Nottingham

On Sheet 1 I have a range of dates in columns A & C. On Sheet 2 I have a list of items that include a date of occurrence in column M. I need a formula on Sheet 2 column A that will evaluate that date of occurrence, determine which date range from Sheet 1 this date falls into, and return the value of the starting date range. So, for the images attached, the formula would return the 5/18/24 date in cell A2 on Sheet 2 because the date of occurrence (6/3/24) falls in between 5/18/24 thru 6/14/24. Date Ranges Formula cell

I am struggling to determine the correct formula.

Continue reading...

Latest posts