I have posted a screen shot so you can see what I am talking about.
I need to determine how many times a staff member provides coverage on specific days. For example, I want to know how many week days (Monday - Thursday) and how many weekend days (Friday - Sunday) "JA" works. I can't figure out the correct formula to do this.
Please help!
Doc1.docx
A screenshot does not help us to help you. Please upload a spreadsheet with any sensitive information removed. As well as how/where you want the answer recorded in the sheet.
Don't just use the answers provided for you. Try to understand how it works by reverse engineering or asking about it.
Please mark the thread as [SOLVED] (Thread Tools->Mark thread as Solved) when answered.
If you're happy with an answer given, please click the * under the person's name to boost their reputation.
For example... I want to take the information from the page "January" and determine when a staff member was on call for cardiology during Mon-Thur period and a Fri-Sun period. This information would get put under stats page.
Call Schedule - SAMPLE.xlsx
Take a look at the attached spreadsheet. Please note that I had to add values to Column K in all the tabs to denote weekend or weekday. You can either hide the column or change the font color to blend in.
CallSchedule-SAMPLE(solution for jlo33).xlsx
I love the idea of that and how it would work. I would prefer to have the 1 or 0 populate itself instead of me manually entering it. I'm trying to come up with a master sheet that can be used every year with minimal changes as I am pretty much the only one in the office that understands Excel. I'm trying to make it as user friendly for everyone else.
weekday() would do that
you need to change the format of cells A or B
so it has a date but only display the day
the you can use =IF(WEEKDAY(B6,2)<6,0,1) in column K to automate the 0 and 1
and in B6 put the date 1/1/13
copy down and format as DD
The format you have set up for the spreadsheets means column A will have to be manually updated for all the months. If you're fine with that, then put this formula in column K
=IF(AND($A6<>"Sat",$A6<>"Sun"),0,1)
of all the months on the above spreadsheet that I uploaded
It works! Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks