I have a table with dates in column a and price in column b. I want to determine the maximum price every 24 hours with the condition that the weekend is excluded. How do I put this as formula?for example, friday 12 pm, it needs to do 12 hours until saturday 00:00 and then skip 48 hours until monday 00:00 and then do the next 12 hours on monday in order to get a full 24 hour cycle.
any ideas?
Bookmarks