Hi Guys,
Not sure what formula I'm supposed to be using. This is a multi part problem.
First problem. I want to go into the code column and apply a code based on whether the date is a public holiday (this has a reference table), a weekday, a Saturday or a Sunday.
Second problem. I want to go into the rate column and apply a rate based on if it is a public holiday (this has a reference table), a weekday, a Saturday or a Sunday. I also want it to reference the Rate table and must be after the correct date. The first date In the table is 1/7/19, then 1/7/20, then 3/7/21. as you can see the rate changes.
ANY help would be appreciated
Screen Shot 2021-11-15 at 6.04.47 pm.png
Bookmarks