Date Forumlas

[LadyDi]

I was just wondering if there is a formula that will return the date of the Saturday of the previous week. In other words, is there a forumla that I can use anytime this week that will return the date 9/11/2010?

 

[chergh]

If you date is in cell A2 this will return the previous saturday

=A2-MOD(WEEKDAY(A2),7)

 

[LadyDi]

Thank you very much. That formula works perfectly. I have one more question. Is there a way to modify the formula to show the previous Sunday's date? I would acutally like to use the formula twice, once to show the previous Saturday's date and once to show the previous Sunday's date (9/5/2010).

 

[chergh]

Yep the following will do it

=A2-MOD(WEEKDAY(A2,2),7)

 

[LadyDi]

Thank you.