PC Review


Reply
Thread Tools Rate Thread

calculate how many Mon, Tue, Wed, Thur, Fri, Sat & Sun in month

 
 
Sunnyskies
Guest
Posts: n/a
 
      19th Jun 2008
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 With Quote
 
 
 
 
Mike H
Guest
Posts: n/a
 
      19th Jun 2008
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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
formula to calculate month-month User Microsoft Excel Misc 2 16th Feb 2010 10:28 AM
Re: How to calculate month Jeff Boyce Microsoft Access Queries 0 10th Oct 2008 11:29 PM
calculate month =?Utf-8?B?Uko=?= Microsoft Excel Worksheet Functions 9 25th Sep 2008 03:06 PM
Calculate the first day of the month for the current month? =?Utf-8?B?QXByaWwgUy4=?= Microsoft Excel Misc 5 27th Jul 2005 08:53 PM
How do I calculate the first day of the next month following a ce. =?Utf-8?B?VmVyb25pY2E=?= Microsoft Excel Worksheet Functions 0 18th Sep 2004 12:49 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:37 PM.