My weekday function aint working

		Microsoft Office Forums > Microsoft Excel > Excel
My weekday function aint working

FAQ

Thread Tools

Display Modes

#13

05-25-2010, 04:42 PM

Kimberly

Windows 7

Office 2010 (Version 14.0)

Expert

Join Date: May 2010

Posts: 517

Nope, I messed up. The formula will include entries made at midnite. This one won't:
=IF(AND(WEEKDAY(A3,2)<6,MOD(A3+0.5,1)=0),"yes","no ")
Then the averageif.

Tags

average if, cse, weekday

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
lastincolumn function	rdcsfd	Excel Programming	7	02-08-2012 07:50 AM
FIND function, where?	Yumin	Word	2	04-02-2010 07:16 PM
Is this possible using the Vlookup or any other function?	Delson	Excel	4	02-08-2010 01:27 PM
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 04:52 PM.