Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><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




<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


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


I want to have these dates to be a working week. i.e Mon-Sunday.<o


<o


Can anyone help me with a formula that will fit this requirement.<o


<o


Thanks<o


Craig