Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how many Fridays in a specific month in Excel
I need to be able to produce a number represneting the amount of times a
specific day occurs in any given month. Thanks fo any help in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how many Fridays in a specific month in Excel
Try this:
A1: (Enter Any Date) B1: (Enter a number from 1 to 7) Note: 1=Sun, 2=Mon, 3=Tue, etc....7=Sat C1: =SUMPRODUCT(--(WEEKDAY(A1-1+ROW($A$1:INDEX(A:A,DAY(EOMONTH(A1,0)))))=B1)) That formula returns the count of days of the type referenced in B1 there are in the month including the value in A1. Example: A1: 2/1/2006 B1: 2 (Monday) C1: returns 4 Is that what you're looking for? *********** Regards, Ron XL2002, WinXP-Pro "Don Ray" wrote: I need to be able to produce a number represneting the amount of times a specific day occurs in any given month. Thanks fo any help in advance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how many Fridays in a specific month in Excel
On Sun, 8 Jan 2006 16:46:02 -0800, "Don Ray" <Don
wrote: I need to be able to produce a number represneting the amount of times a specific day occurs in any given month. Thanks fo any help in advance With some date in the month in A1: =4+(DAY(A1-DAY(A1)+1-WEEKDAY(A1-DAY(A1+5))+35)7) will give the number of Fridays in a month. For a different weekday, change the '5' near the end accordingly: 1:Monday 7:Sunday --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I select cells for a specific month in Excel 2003? | Excel Worksheet Functions | |||
In Excel How do I return the Month for a specific date | Excel Discussion (Misc queries) | |||
Calculating the number of Fridays in a month | Excel Worksheet Functions | |||
Make an Excel series of first and third fridays of each month? | Excel Discussion (Misc queries) | |||
Counting Fridays in a month | Excel Programming |