Can you tell me what formula should i use in gsheet in getting the date between a range and displays the first date of the range. SAMPLE DATE (END DATE): 073124 then specifically the date range where this given date falls between 071124-090824 in the series of ranges. I need the 051224 to autodisplay in Column B shown below.
START |END
|070124 |073124 | | occurence code | Column B |
| date range |
01/13/24 03/12/24
03/13/24 05/11/24
05/12/24 07/10/24
07/11/24 09/08/24 |
TRIED =IF (ISNA(VLOOKUP(C5,A13:B24,2,FALSE)), “0”) BUT DISPLAYS THE CORRESPONDING DATE NEXT TO IT. Sorry i’m still learning. :((
Stefany grace Genita is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.