I am trying to set up a schedule and need to use a calendar so that I don't
get weekend in the mix. I'm not sure how to go about doing this.

Thanks in advance
--
DMM

DMM

Type 5/26/08 (or 26/5/08, if you are in Europe) into cell A2 (you can use any valid date for a
Monday - this is just an example).
In cell A3, type the formula
=A2+1
and copy down to A4:A6.
In A7, enter the formula
=A2+7
and copy that down as far as you need dates of weekdays.

Then when you sheet is set up, you can change the date entered in A2 and all the other dates will
change.

HTH,
Bernie
MS Excel MVP


"soconfused" wrote in message
...
I am trying to set up a schedule and need to use a calendar so that I don't
get weekend in the mix. I'm not sure how to go about doing this.

Thanks in advance
--
DMM

That would help, but how do I incorporate that into a formula like this:

L35-(E35/3-1).

What I am trying to do is ignore all North American holidays and weekends.

--
DMM


"Bernie Deitrick" wrote:

DMM

Type 5/26/08 (or 26/5/08, if you are in Europe) into cell A2 (you can use any valid date for a
Monday - this is just an example).
In cell A3, type the formula
=A2+1
and copy down to A4:A6.
In A7, enter the formula
=A2+7
and copy that down as far as you need dates of weekdays.

Then when you sheet is set up, you can change the date entered in A2 and all the other dates will
change.

HTH,
Bernie
MS Excel MVP


"soconfused" wrote in message
...
I am trying to set up a schedule and need to use a calendar so that I don't
get weekend in the mix. I'm not sure how to go about doing this.

Thanks in advance
--
DMM

That would help, but how do I incorporate that into a formula like this:

L35-(E35/3-1).

=:-) ? Incorporate that how? What is in L35? in E35?

Bernie
MS Excel MVP

L35 is a date. I'm trying to take a date and subtract out hours to get a new
date and I can't include weekends or holidays.

--
DMM


"Bernie Deitrick" wrote:

That would help, but how do I incorporate that into a formula like this:

L35-(E35/3-1).

=:-) ? Incorporate that how? What is in L35? in E35?

Bernie
MS Excel MVP

DMM,

So, do you have an end date, and want to calculate an earlier date that gives you a certain number
of workdays?

Or do you have an start date, and want to calculate an later date that gives you a certain number of
workdays?

Bernie
MS Excel MVP


"soconfused" wrote in message
...
L35 is a date. I'm trying to take a date and subtract out hours to get a new
date and I can't include weekends or holidays.

--
DMM


"Bernie Deitrick" wrote:

That would help, but how do I incorporate that into a formula like this:

L35-(E35/3-1).

=:-) ? Incorporate that how? What is in L35? in E35?

Bernie
MS Excel MVP