View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pau1a
 
Posts: n/a
Default Count number of dates

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