Hello driller2

=WORKDAY(A1,-1) would give you the previous workday so if A1 is a Saturday
or a Sunday it gives the previous Friday, similarly

=WORKDAY(A1,-7) gives the Thursday of the week before if A1 is a Saturday or
Sunday.

"driller2" wrote:


Hi to all,
I tried that original posted formula of christine and it indeeds give
me a result on excel 2003, yet i am still blinded by the two different
results.

if Datefrom is typed as a date that falls on saturday or sunday (this
is a non-workday)
and if Datefrom is typed as a date that falls on friday.

maybe i am confused. When does the -7 starts deducting?
maybe Christine can give an example.

happy holidays hohoho
romelsb:)




--
driller2