Hi

I have a date that I would like to subtract a set number of days from, but
do not want to include weekends. For example:

Date: 13/02/09 Number of Days to subtract: 10 result should be: 30/01/09

Can anyone help

Thanks

I have just been advised that we are now only going to be working 4 days a
week, so I also need to exclude Fridays!

"The Rook" wrote:

Hi

I have a date that I would like to subtract a set number of days from, but
do not want to include weekends. For example:

Date: 13/02/09 Number of Days to subtract: 10 result should be: 30/01/09

Can anyone help

Thanks

In normal situation the answer would be:
=WORKDAY(C1,-10)
For 4 working day weeks I can suggest a workaround:
Enter 2/1/09 (first Friday in 2009) in the first row of en empty column, say
in E1,
enter in E2: =E1+7
fill it down throgh 52 rows (52 weeks of the year)
add usual holidays to this column, then your formula is
=WORKDAY(C1,-10,E1:E52)
or
=WORKDAY(C1,-10,E1:E??) if holidays are entered.


Regards,
Stefi

€žThe Rook€� ezt Ã*rta:

I have just been advised that we are now only going to be working 4 days a
week, so I also need to exclude Fridays!

"The Rook" wrote:

Hi

I have a date that I would like to subtract a set number of days from, but
do not want to include weekends. For example:

Date: 13/02/09 Number of Days to subtract: 10 result should be: 30/01/09

Can anyone help

Thanks