Hello there,
I got an Excel test in a company and one of the questions is to create a salary calculator that takes into account shifts and weekends for one month.
Given I am supposed to work for them in Marketing, I don't know why this question exists but I would really like some help.
I know a couple of things about programming and if you used any language you would just get the number of the workdays by the table, deduct the number of rest days and then assign variables to each shift and then to Sundays and this way you would calculate the salary pretty easily.
With excel though my knowledge doesn't go that far. I suppose you could use countIF and multiple IF functions but it gets messy very fast.
Any help would be greatly appreciated
I attach a makeshift schedule I made with some guidelines:
Excel.jpg
Bookmarks