Previous Monday Date

[KAZ393]

I have cell D7 for date entry, I need to allow the user to only input the previous Monday weeks date,not the current Monday.of the week use,

Has any body got any idea of how i can apply this in data validation

Urgent Help needed

I am at the point of insanity

Can anyone out there help me

Thanks

 

[Yogi Anand]

Hi KAZ393:

Welcome to the Board!

Try ... =TODAY()-WEEKDAY(TODAY())+2
for DATA|Validation for cell of interest.

 

[inarbeth]

Hi, Yogi I think the formula should be =A1=TODAY()-WEEKDAY(TODAY())-5 to get the Monday in the previous week, where A1 is the cell you want to validate. Without the =A1 bit the validation does not work.

 

[Yogi Anand]

Hi inarbeth:

You are right -- I had mistakenly read 'Previous Monday' instead of 'Monday of Previous week'. As far as applying the validation to a particular cell is concerned I had left it upto the OP to make the association -- Thanks!