I am trying to get excel to return a cells value based on the month of the year. I currently have two sheets, a table sheet and a display sheet.
It is being used to track employee hours on a rotating calendar.
But want I would like it to do is automatically display the current months value. I tried to use a nested IF statement, but I would need 12, rather than the limit of 7.
I set up a cell to read the current months total hours by month, I want the value to appear in the Drop Off Hours column, but without the nested IF statement I don't know what to do next.
Any help would be greatly appreciated.
Here is my current setup.
Officer Hours Tracking.xlsx
Bookmarks