Hi All,
I have a problem which is probably simple to you guys, but an awful one for me!
See The Attached Spreadsheet.
What I want is, for each guy in Column AN to have a sum which works out how many claims they have booked in excluding cells with LETTERS between day 1 of Month, UP TO AND INCLUDING the DAY from the TODAY Function in Cell A2.
Then in Column AO, I want similar, but just a count of the days excluding BLANKS and LETTERS that the member of staff was available between day 1 of Month, UP TO AND INCLUDING the DAY from the TODAY Function in Cell A2.
Please can you help it's driving me Crazy!
Thanks a lot!
Chris
Bookmarks