my timesheet looks like this. guess how i’ve spent the previous month!
more excel madness:
1. dropdown month selector
2. year open field
makes for a nice auto-updating calendar
worse of all was
just coz excel doesnt have a simple function to check whether a text is found in a list and return a yes/no string. 3 nested IF statements plus ISERROR and VLOOKUP in order to check for weekends and public holidays, compared to just one IF and one OR for only weekends.
did you know excel can do up to 32 nested IF statements? it is a pain to close the brackets.
and some fluff:
to display number of days in the month. omg what is that huh.