Expression help for day of current week

[Pratyay_Rakshit]

Does this properly signify ‘Monday of the current week’, for a [Date]? :

and
(
weekday([Date])=2,
totalhours(today()-[Date])/24 < 7
)

?

[Suvrutt_Gurjar · Accepted solution]

As per my understanding, the above expression will have a slight overlap in detecting Monday of the current week. For example, if today is 23rd November (23/11/2020), then I believe the expression will return True for Monday (23/11/2020) as well as Monday (30/11/2020) and Monday (16/11/2020)

Maybe you wish to try the following expression, which is based on the expressions shared by @Steve in WEEKDAY() for Friday of the current week, modified for Monday as below.

(TODAY()- WEEKDAY(TODAY()) + 2)=[Date]

Please test well.

help.appsheet.com

WEEKDAY()

Day of week from Date or DateTime