Date Question

[ststern45]

Happy Holidays everyone,

I have a date formula question.

In cell column 1 through 1000 I have a list of invoice dates from most current 12/25/2022 in cell A1 and the last date July 5, 2021 in cell A1000.
There are some dates that are missing and dates that are duplicates. The duplicate dates follow each other and not scattered throughout cell range A1 through A1000.
My question is the following:

Suppose I have a date 12/1/2022 but the next available date is 11/28/2022. Can a formula calculate the 1st date before 12/1/2022
Or calculate how many dates for December 2022 are in cell range A1 through A1000, how many dates for November 2022 are in cell range A1 through A1000?

Thank you in advance!!

 

[bebo021999]

Not too difficult, if you could post a sample sheet (via XL2BB)

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com

 

[ststern45]

I found a solution
=SUMPRODUCT((MONTH($A$1:$A$100)=$B$1)*(YEAR($A$1:$A$100)=$C$1))
Thanks