Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Excel
Needs help to find excel formula- Please Needs help to find excel formula- Please
Register FAQ Members List Social Groups Search Today's Posts Mark Forums Read

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 07-12-2009, 04:52 AM
aamer_1983 aamer_1983 is offline Windows XP Office 2003 (Version 11.0)
Novice
  
Join Date: Jul 2009
Posts: 1
aamer_1983 is on a distinguished road
Default Needs help to find excel formula- Please
Good Morning Guys,

I need your help to find the suitable formula for the attached excel sheet which highlighted in red and it’s related to how to count the Fridays and Saturdays for the specific month. Please open the attached excel sheet.

Your prompt reply and help will be highly appreciated.

Regards,
Attached Files
File Type: zip Example.zip (4.2 KB, 4 views)
Reply With Quote
  #2  
Old 07-12-2009, 10:47 AM
boutells boutells is offline Windows Vista Office 2007 (Version 12.0)
Novice
  
Join Date: May 2009
Posts: 19
boutells is on a distinguished road
Default
You might have a problem as you are displaying dates which are numeric as days. If the days are numeric in the calendar then each Friday has a different value from the other Fridays and therefore it will only count once.

If you can set up the table so the day is alpha and not numeric then you could use =COUNTIF(B9:AC9,"Fri")
Reply With Quote
  #3  
Old 07-13-2009, 04:46 AM
boutells boutells is offline Windows Vista Office 2007 (Version 12.0)
Novice
  
Join Date: May 2009
Posts: 19
boutells is on a distinguished road
Default
Try using the weekday function followed by the countif function. See attached.
Attached Files
File Type: xls Example.xls (34.0 KB, 2 views)
Reply With Quote
Reply

Bookmarks

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

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 Off
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
help with find and replace sjkiss Word 1 04-12-2010 11:08 AM
Find and Replace is not working Brigitte Word 4 11-24-2009 10:42 AM
Excel Formula Help masoom84 Excel 1 03-07-2009 11:41 AM
Excel Formula Help Shahzad Excel 1 12-07-2008 06:13 AM
Find and Replace Macro - A Better Way Tribos Word 0 10-08-2008 06:22 AM


All times are GMT -4. The time now is 10:40 PM.

Contact Us - Top

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.