Excel - Monday/ Previous Week Validation 4

[Guest_imported]

I need to validate a cell so that only the date of the Monday of the previous week will be accepted.

I have Monday validated by WEEKDAY, but am having difficulty restricting the date.

Any help would be appreciated.

With Thanks,

Maureen

 

[Guest_imported]

Thanks for rescuing me from the wood where I couldn't see the trees. <g>

I'll double check, but I think I have all the criteria met now ... so with luck I'll be leaving you in peace, but

forever in your debt ...

Mo

 

[Guest_imported]

It gets even better ... and I've included :'s too! <G>

I can't think of a new way to say it, so please will you settle for an action replay ...

&quot;THANK YOU&quot;

With all best wishes ...

Mo

 

[Dreamboat]

Mo, I thought for sure that you sat on your enter button when I saw about 15 posts from tek-tips when I got home!!

LOL LOL LOL
techsupportgirl@home.com

http://www.WeDoManuals.com

Brainbench MVP for Microsoft Word at

http://www.brainbench.com

 

[Guest_imported]

With Dark Sun in the guise of a knight in shining armour I was glued to it!!! <GgggG>

Mo

 

[Dreamboat]

|-0 Wow! I hope you can get it off!
techsupportgirl@home.com

http://www.WeDoManuals.com

Brainbench MVP for Microsoft Word at

http://www.brainbench.com