Hello,
I create sheets that are used the next day. I would like to find a way to
calculate tomorrow's date, Monday-Fri, with no holidays included. I haven't
found a way to make it work yet.

i.e:

today()+1 - weekend, holidays

Thank you for your advice!

Monique

On Tue, 8 Mar 2005 09:39:13 -0800, "Monique"
wrote:

Hello,
I create sheets that are used the next day. I would like to find a way to
calculate tomorrow's date, Monday-Fri, with no holidays included. I haven't
found a way to make it work yet.

i.e:

today()+1 - weekend, holidays

Thank you for your advice!

Monique

Take a look at the WORKDAY function:

=WORKDAY(TODAY(),1,Holidays)




--ron

I am not sure how this expression is suppose to be written. I tried it all
the ways I could think of; including copying your example, but I haven't
found the solution yet.

"Ron Rosenfeld" wrote:

On Tue, 8 Mar 2005 09:39:13 -0800, "Monique"
wrote:

Hello,
I create sheets that are used the next day. I would like to find a way to
calculate tomorrow's date, Monday-Fri, with no holidays included. I haven't
found a way to make it work yet.

i.e:

today()+1 - weekend, holidays

Thank you for your advice!

Monique

Take a look at the WORKDAY function:

=WORKDAY(TODAY(),1,Holidays)




--ron

On Tue, 8 Mar 2005 17:03:01 -0800, "Monique"
wrote:

I am not sure how this expression is suppose to be written. I tried it all
the ways I could think of; including copying your example, but I haven't
found the solution yet.

I don't know how to respond helpfully to your statement.

But perhaps if you convey exactly what you wrote, and exactly what happened,
and exactly what you expect to happen, I might be able to respond.

Did you check HELP for the function?



--ron

Hi Ron,
I am new to Excel and unfamiliar with the order and syntax of functions and
formulas. I am using my speadsheet to learn about Excel functions, and to
automate one of my tasks at work. I am not sure how to include holidays
since I do not have all of them off. I

I did find a formula that will work, however, it does not include holidays.
I tried to put in the holiday function. The dialog box said I had too many
arguments.
i.e.
=IF(WEEKDAY(TODAY())5,TODAY()-WEEKDAY(TODAY(),3)+7,TODAY()+1)

My intention is to automate the date of my spreadsheet so that it updates
itself to display the next day's date, within a five day work week, minus
holidays.

I did use the help files. It said, "you need help". ;)



"Ron Rosenfeld" wrote:

On Tue, 8 Mar 2005 17:03:01 -0800, "Monique"
wrote:

I am not sure how this expression is suppose to be written. I tried it all
the ways I could think of; including copying your example, but I haven't
found the solution yet.

I don't know how to respond helpfully to your statement.

But perhaps if you convey exactly what you wrote, and exactly what happened,
and exactly what you expect to happen, I might be able to respond.

Did you check HELP for the function?



--ron

On Tue, 8 Mar 2005 22:33:03 -0800, "Monique"
wrote:

Hi Ron,
I am new to Excel and unfamiliar with the order and syntax of functions and
formulas. I am using my speadsheet to learn about Excel functions, and to
automate one of my tasks at work. I am not sure how to include holidays
since I do not have all of them off. I

I did find a formula that will work, however, it does not include holidays.
I tried to put in the holiday function. The dialog box said I had too many
arguments.

From HELP:

Holidays is an optional list of one or more dates ...

==================

What that means is that in some contiguous range, you place a list of the dates
which represent holidays. For example:

D1: 25 Mar 2005
D2: 30 May 2005
D3: 4 Jul 2005
..
..
..
D7: 24 Dec 2005
D8: 25 Dec 2005


You then insert the range reference (D1:D8) into the formula I posted in place
of the word "Holidays".

OR, you can name this range Holidays. On the main menu bar:
Insert/Name/Define and then in the Dialog box that opens, type Holidays in the
top box; and the range D1:D10 into the refers to box. Hit <OK.


--ron