Thread: Calculating the number of a Mondays between two dates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Calculating the number of a Mondays between two dates
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))=2))


"AChua" wrote:

Is there a function which can calculate the number of a specified weekday
between two dates?
e.g. How many Mondays there are between 01/07/08 and 01/08/08?


Reply With QuoteReply With Quote