Looking for help drafting a formula which would be used in a dashboard eventually. I would like a search which gives me the bank balance as of the previous Friday. I assume I need a CASE WHEN incorporated with a datetime function... any ideas?