software

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?!

Hi!

Try this:

=SUMPRODUCT(--(TEXT(ROW(INDIRECT(A1amp;quot;:quot;amp;A2)),quot;mmmdquot;)=quot;Apr6quot;))

Biff

quot;pau1aquot; lt;u19999@uwegt; wrote in message news:5da753eb2f65e@uwe...
gt; Hi,
gt;
gt; I want to put a formula on a spreadsheet to calculate the number of 6
gt; Aprils
gt; between two dates.
gt;
gt; For example
gt; A1=1/1/1990
gt; A2=1/1/1993
gt; There would be three 6 Aprils.
gt;
gt; I would imagine that I could do this using a combination of Ifs and
gt; DateDiffs
gt; but it seems that there must be an easier way!
gt;
gt; Any ideas?!
Thanks that works!

You're welcome!

Biff

quot;pau1aquot; lt;u19999@uwegt; wrote in message news:5da7f487540ba@uwe...
gt; Thanks that works!