Is there a simple formula for showing the date from for example monday this week (so from the current week). Or Friday this week etc.
Subject: Formula for Date
Gert,
Probably best to investigate @Weekday
So - if you want a Friday - see what @Weekday returns for today (Sunday=1, Mopnday=2 and so on) and then add/subtract the relevant number of days
HTH
Mike