| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting number of Sundays
On Wed, 26 Mar 2008 14:26:03 -0700, Excelman
wrote: 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) =INT((A2-WEEKDAY(A2)-A1+8)/7) --ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting calendar Days - not including Sundays | Excel Discussion (Misc queries) | |||
| how do i sum day of the week without counting sats and sundays? | Excel Worksheet Functions | |||
| Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
| Number of sundays | Excel Programming | |||
| counting Sundays between two dates | Excel Programming | |||
Threaded Mode
