| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculate how many Mon, Tue, Wed, Thur, Fri, Sat & Sun in month
Afternoon from Sunny RSA,
Looking for a formula that will calculate how many Days (M, T, W, T, F, S & S) in a particular month (cell c5). Example: 2008/04/01 (c5) [Formated as mmmyy) M (c7) = 4 T (c8) = 5 W (c9) = 5 T (c10) = 4 F (c11) = 4 S (c12) = 4 S (c13) = 4 Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculate how many Mon, Tue, Wed, Thur, Fri, Sat & Sun in month
Hi,
Try this =SUMPRODUCT(--(WEEKDAY(EOMONTH($C$5,-1)+ROW($A$1:INDIRECT("$A$"&DAY(EOMONTH($C$5,0))))) =ROW(A1))) Array enter for Sundays then drag down to Monday etc Mike "Sunnyskies" wrote: Afternoon from Sunny RSA, Looking for a formula that will calculate how many Days (M, T, W, T, F, S & S) in a particular month (cell c5). Example: 2008/04/01 (c5) [Formated as mmmyy) M (c7) = 4 T (c8) = 5 W (c9) = 5 T (c10) = 4 F (c11) = 4 S (c12) = 4 S (c13) = 4 Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate month | Excel Worksheet Functions | |||
| calculate year and month | Excel Discussion (Misc queries) | |||
| How to calculate days in the month | Excel Discussion (Misc queries) | |||
| Adding Days (i.e. Mon, Tue, Wed, Thur...) to sheet | Excel Discussion (Misc queries) | |||
| Calculate the first day of the month for the current month? | Excel Discussion (Misc queries) | |||
Hybrid Mode
