Last week start and end dates

[craig80]

Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I am working with EOMONTH and a few other functions. But can't seem to work out how to get last working week.<o></o>
<o></o>
I have a Marco that opens some template wbs, pulls data in from a source, then calculates based on dates in predefined fields.<o></o>
<o></o>
I want to have these dates to be a working week. i.e Mon-Sunday.<o></o>
<o></o>
Can anyone help me with a formula that will fit this requirement.<o></o>
<o></o>
Thanks<o></o>
Craig

 

[Darren Bartrup]

Do you mean last working week - as in last week based on todays date, or last week based on end of month date?

For last Monday and last Friday:

=TODAY()-WEEKDAY(TODAY(),3)-7

=TODAY()-WEEKDAY(TODAY(),3)-3

For last full week of month:

=EOMONTH(TODAY(),0)-WEEKDAY(EOMONTH(TODAY(),0),3)-7

=EOMONTH(TODAY(),0)-WEEKDAY(EOMONTH(TODAY(),0),3)-3