Calulating the last sayurday of a week using vba

[ibeetb]

I am trying to write a formula, using vba to give me the date of the last
saturday from 'Today's date'. For example, if today is Monday, what is the
date of last saturday....

Any ideas?

 

[Pete McCosh]

Assume the date you're using as the start point is stored
in variable x, then:

y = x - (weekday(x) + 1)

will give you last Saturday's date in y, assuming you
haven't changed the FirstDayofWeek constant from Sunday.

Cheers, Pete

 

[Myrna Larson]

Hi, Pete:

Your code as written gives ME the previous Friday, not Saturday. You don't want to add 1 here.
i.e. it should be just

y = x - Weekday(x)

Myrna Larson