Forum Discussion

Derick63's avatar
Derick63
Copper Contributor
Aug 27, 2022
Solved

Get earliest posted date within given month and year from range of dates

Hello all. I've been banging my head trying to find a way to get a particular date from a range of dates. Here's the scenario; I have two named cells on a worksheet, one with the month August as a v...
excel
Formulas and Functions
  • Derick63's avatar
    Derick63
    Aug 28, 2022

    Solution: Column B is where the dates are. Array MIN, IF and Year returns the earliest date for year 2022, from range B9:B1009


    {=MIN(IF(YEAR(INDIRECT(NisConMth & "!B9:B1009"))=NisConYr, INDIRECT(NisConMth & "!B9:B1009")))}


    I did not need to include the month in the criteria since it was already in the month sheet. Looking for the earliest date within the latest year was the solution

Derick63's avatar
Derick63
Copper Contributor
Aug 28, 2022

Solution: Column B is where the dates are. Array MIN, IF and Year returns the earliest date for year 2022, from range B9:B1009


{=MIN(IF(YEAR(INDIRECT(NisConMth & "!B9:B1009"))=NisConYr, INDIRECT(NisConMth & "!B9:B1009")))}


I did not need to include the month in the criteria since it was already in the month sheet. Looking for the earliest date within the latest year was the solution

Resources