dpaton05
Well-known Member
- Joined
- Aug 14, 2018
- Messages
- 2,352
- Office Version
- 365
- 2016
- Platform
- Windows
I have a table with a cell that contains this function
This formula looks up the cost of a public holiday in another sheet if the date in the date column is new years day of any year. I want that same cell to look up the same cost if the date is Christmas or Boxing day. How do I combine the function to check if it is the 25/12 or 26/12 for any year?
Excel Formula:
=IF([Date]=DATE(YEAR([Date]),1,1),INDEX(Sheet2!$A$5:$E$12,MATCH([Service],Sheet2!$A$5:$A$12,0),MATCH("Public_holiday",Sheet2!$A$5:$E$5,0)), 0)
This formula looks up the cost of a public holiday in another sheet if the date in the date column is new years day of any year. I want that same cell to look up the same cost if the date is Christmas or Boxing day. How do I combine the function to check if it is the 25/12 or 26/12 for any year?