Formula for Date

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