assuming your dates are in A1:A7 and todays date is in cell C1, try:

=SUMPRODUCT(--(TEXT(A1:A7,"mmyy")=TEXT(C1-DAY(C1),"mmyy")))


"Victor Delta" wrote:

I have an Excel spreadsheet which includes a column containing dates.

I am trying to create a formula which will tell me the number of cells in
the column that have dates from last month. For some unknown reason I am
having great difficulty with this - even before trying to ensure the formula
will cope with the December/January issue, when the 'month-1' principle
presumably will not work.

Can anyone help please?

Thanks,

V