Count number of dates

[pau1a]

Hi,

I want to put a formula on a spreadsheet to calculate the number of 6 Aprils
between two dates.

For example
A1=1/1/1990
A2=1/1/1993
There would be three 6 Aprils.

I would imagine that I could do this using a combination of Ifs and DateDiffs
but it seems that there must be an easier way!

Any ideas?!

 

[Biff]

Hi!

Try this:

=SUMPRODUCT(--(TEXT(ROW(INDIRECT(A1&":"&A2)),"mmmd")="Apr6"))

Biff

 

[pau1a]

Thanks that works!

 

[Biff]

You're welcome!

Biff