Thread: My weekday function aint working
View Single Post
 
Old 05-25-2010, 04:42 PM
Kimberly Kimberly is offline Windows 7 Office 2010 (Version 14.0)
Expert
  
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default
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.
Reply With Quote