Can I imbed a calendar to us with functions?

[soconfused]

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

 

[Bernie Deitrick]

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]

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.

 

[Bernie Deitrick]

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

 

[soconfused]

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.

 

[Bernie Deitrick]

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]

I have an end date and need to schedule backwards.

So, if my end date is 12/19/08 and the previous operations calls for 4
hours, I need to schedule back 4 hours.

 

[Bernie Deitrick]

DMM,

So, if my end date is 12/19/08 and the previous operations calls for 4
hours, I need to schedule back 4 hours.

4 hours back from 12/19 may also be 12/19, depending on:

What time on the date?
Does your date have a time as well?
What is your standard workday - 24 hours, or 7AM to 5PM?
Do you need to account for lunch?
Is the difference always hours, or do you also need days? Weeks? Months?

Bernie
MS Excel MVP