this last Saturday's date

How do I get this last saturday's date in a cell?

if you want a rolling date you could have

Please Login or Register  to view this content.

or if you want time and date you could use

Please Login or Register  to view this content.

Hope this is what you are after.

Regards,
Simon

p.s if you want it every staurday from saturday you need to change the -6 to -7, so the date will always show a week ago!

I want it to show the previous saturday whether I run it today or yesterday or last monday. And if I were to look at the file next week I want it to show tomorrow's date.

Hi,

Are you after

Please Login or Register  to view this content.

to always get previous Saturday ...

HTH
Carim

That's the one, Thanks!

Glad your problem 's fixed ...

Thanks for the feedback

Carim