I need some help trying to calculate a date.
I have a month end date of 1st April 07. I then have a timetable which
states 1 day later I should do these tasks, 2 days later these other tasks.
I have a formula which calculates the date that these items are due which is
month end date plus 1 for 1 day later, 2 for 2 days later etc. I need to
ensure that the date given does not include Saturday and Sunday. Is there a
formula I can use without manually changing the days later figure?

Thanks

You need the workday function

=WORKDAY(A1,10)

Adds 10 working days to a date in A1. It is also capable of taking holidays
into account so check out help if this is required.

Mike


"Funkyfido" wrote:

I need some help trying to calculate a date.
I have a month end date of 1st April 07. I then have a timetable which
states 1 day later I should do these tasks, 2 days later these other tasks.
I have a formula which calculates the date that these items are due which is
month end date plus 1 for 1 day later, 2 for 2 days later etc. I need to
ensure that the date given does not include Saturday and Sunday. Is there a
formula I can use without manually changing the days later figure?

Thanks

This calculates the date better but does not exludes Saturdays and Sundays

"Funkyfido" wrote:

I need some help trying to calculate a date.
I have a month end date of 1st April 07. I then have a timetable which
states 1 day later I should do these tasks, 2 days later these other tasks.
I have a formula which calculates the date that these items are due which is
month end date plus 1 for 1 day later, 2 for 2 days later etc. I need to
ensure that the date given does not include Saturday and Sunday. Is there a
formula I can use without manually changing the days later figure?

Thanks

It does for me. Try adding 10 days to 1/1/2007 and you'll find it gives an
answer of 15/1/2007

"Funkyfido" wrote:

This calculates the date better but does not exludes Saturdays and Sundays

"Funkyfido" wrote:

I need some help trying to calculate a date.
I have a month end date of 1st April 07. I then have a timetable which
states 1 day later I should do these tasks, 2 days later these other tasks.
I have a formula which calculates the date that these items are due which is
month end date plus 1 for 1 day later, 2 for 2 days later etc. I need to
ensure that the date given does not include Saturday and Sunday. Is there a
formula I can use without manually changing the days later figure?

Thanks