aamer_1983 Posted July 12, 2009 Share Posted July 12, 2009 Good Morning Gays,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,Example.zip Link to comment Share on other sites More sharing options...
jaclaz Posted July 12, 2009 Share Posted July 12, 2009 (edited) You may want to check the actual position on your keyboard of the "u" and "a" keys. In Cell B9:=WEEKDAY($B$5+B8-1;2)copy up to AC9In cell AD9:=IF($I$12=AC8;"";WEEKDAY($B$5+AC8-1;2))in AD8:=IF($I$12>AC8;AC8+1;"")copy up to AF8in AD9:=IF(AD8<>"";WEEKDAY($B$5+AD8-1;2);"")copy up to AF9in I15:=COUNTIF($B$21:$AF$21;5)in I16:=COUNTIF($B$21:$AF$21;6)Read the help for the parameters of WEEKDAY (bolded) and in case change the argument of COUNTIF (bolded underlined italic)jaclaz Edited July 12, 2009 by jaclaz Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now