Thread: how many times a particular day of the week appears in a given month
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
daddylonglegs daddylonglegs is offline
external usenet poster
  
Posts: 1
Default how many times a particular day of the week appears in a given month

You say you have column for the month and column for the day.

If the month has been input in the format Aug-06 and day is the full
weekday, e.g. "Wednesday" then assuming date in A2 and weekday in B2

=SUMPRODUCT(--(TEXT(ROW(INDIRECT(A2&":"&A2+31-(DAY(A2+31)))),"dddd")=B2))


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=568898

Reply With QuoteReply With Quote