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
|