Forum Discussion
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...
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
If I understand your description correctly, all dates on the August sheet are within the pay range for August. So can't you simply use the MIN function to get the earliest date?
There's a previous Year, 2021, on that sheet