Date Formula -2w but only a Monday Date

Sara F

I'm trying to create a formula that uses "Program Date" and returns 2 weeks prior, but on a Monday date.

I have this formula to give me -2w but cannot figure out how to make it a Monday date only

=[Program Date]@row - 14

kowal

hi @Sara F,

I think you need to use extra formula:

=weekday()

if it returns you "2" it means the date is Monday.

Hope this helps!