Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page My weekday function aint working
Register FAQ Mark Forums Read

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #11  
Old 05-25-2010, 03:10 PM
Kimberly Kimberly is offline My weekday function aint working Windows 7 My weekday function aint working Office 2010 (Version 14.0)
Expert
  
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default
I didn't mean to seem rude either.

In a helper column: =IF(AND(WEEKDAY(A3,2)<6,MOD(A3,0.5)=0),"yes","no")
then =AVERAGEIF(C3:C289,"yes",B3:B289)
Reply With Quote
 

Tags
average if, cse, weekday

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
My weekday function aint working lastincolumn function rdcsfd Excel Programming 7 02-08-2012 07:50 AM
My weekday function aint working FIND function, where? Yumin Word 2 04-02-2010 07:16 PM
My weekday function aint working Is this possible using the Vlookup or any other function? Delson Excel 4 02-08-2010 01:27 PM
My weekday function aint working Need help on what function to use??? Primeraman Excel 1 06-13-2006 10:16 AM
Help with Combination function sanasath Excel 0 12-13-2005 07:24 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:56 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft