Hi guys,
I have a spreadsheet I am using to track holidays on. I am learning to use format control and index match etc.
I need seperate tabs which you can see whereby i have setup 'April 2019' and 'May 2019' and a tab called holiday sheet.
Can anyone help me with inputting the dates into the holiday tab whereby, if i inset date - to date in April (after selecting April using the format control box on the holiday tab) the figure for April is populated on the holidays column in the April 2019 tab
Similarly if I insert another range of dates of holiday on the holiday sheet tab for the month of may, the number of days off is inserted into the may 2019 tab against john smith. Sheet attached!
Thank you guys!
Bookmarks