Ah, sorry, this has become awkward.

The cells in column A are for individual days, 1400 in all, from
01.01.2000. The idea was to create a range of 1 month, using the method
posted before. The 2 cells to determine the range a

C1: =COUNTIF(A1:A1429,""&B4)
C2: =COUNTIF(A2:A1429,"="&B6),

where the cells in column B give the first and last dates of the
selected month (01.02.00 and 29.02.00, for example).

However, using this example, what is being posted is 01.10.03-28.10.03
and 27.01.03.

Any suggestions on why?

TIA

Steve