Subtracting number of days excluding the weekend

T

The Rook

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
 
T

The Rook

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!
 
S

Stefi

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If Tuesday subtract 4 (Formulas) 3
calculate number of days 7
Counting Days of Week 2
Eliminating weekends when subtracting dates 1
Date + X days excluding holidays 1
Formula help: Duration Without Weekend Days 4
Excel 2002: How to get the number of days in the month ? 8
how would i use excel to find the number of days------- 2

Top