View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Excelman Excelman is offline
external usenet poster
 
Posts: 9
Default Counting number of Sundays

I am looking for a formula that will count the number of Sundays within a
date range. Example: I want to enter a start date in one cell, and today's
date in another,and need a formula that will count the number of Sundays
between the two.A1 3/01/2008
A2 3/31/2008
A3 5 (5 Sundays between the dates)