Good morning,
I have a column with date, which I would like to assign to new columns: "attended" and "upcoming", based on past 5 working days and upcoming 5 working days. Report will be updated on a weekly basis (Mondays).
If in a past then should turn in column "attended" with number 1, if not then 0. Same rule applies for column "upcoming".
I tried to solve it via conditional formatting, but this is not giving me the result I am looking for.
Thank you very much for the support.
Bookmarks