Naturally in the event open wbook

is possible to insert in the column K of this sheet the range of da
for not used this sheet (add this range of date not used to up o
existing date and not delete existing date).

Note: i have insert in autoclose of this sheet a comand to save i
always.

Example:

i open the sheet on 01/09/2004
i close in the same date (and autosave)

i reopen this after 12 day

when i open the sheet insert in the column K the step of date relativ
to not used this sheet with not deleted the exinsting date up from th
last util cell

in this case

02/09/2004
03/09/2004
04/09/2004
07/09/2004
08/09/2004
09/09/2004
10/09/2004
11/09/2004


consider:

without :Saturday Sunday

without :Cristmas, New Year's Day,

without : a range of date to refer the national italian holyday (refre
in another column of the sheet, this is a range free for inserting)

in effect refer to a complete calendar day with only a work day...


http://www.gssitaly.com/test.zip

I hope of to have been clea

--
sal2

-----------------------------------------------------------------------
sal21's Profile: http://www.excelforum.com/member.php...nfo&userid=204
View this thread: http://www.excelforum.com/showthread.php?threadid=26330

Hi
have a look at the WORKDAY function

--
Regards
Frank Kabel
Frankfurt, Germany

"sal21" schrieb im Newsbeitrag
...

Naturally in the event open wbook

is possible to insert in the column K of this sheet the range of day
for not used this sheet (add this range of date not used to up on
existing date and not delete existing date).

Note: i have insert in autoclose of this sheet a comand to save it
always.

Example:

i open the sheet on 01/09/2004
i close in the same date (and autosave)

i reopen this after 12 day

when i open the sheet insert in the column K the step of date
relative
to not used this sheet with not deleted the exinsting date up from
the
last util cell

in this case

02/09/2004
03/09/2004
04/09/2004
07/09/2004
08/09/2004
09/09/2004
10/09/2004
11/09/2004


consider:

without :Saturday Sunday

without :Cristmas, New Year's Day,

without : a range of date to refer the national italian holyday
(refred
in another column of the sheet, this is a range free for inserting)

in effect refer to a complete calendar day with only a work day...


http://www.gssitaly.com/test.zip

I hope of to have been clear


--
sal21


---------------------------------------------------------------------
---
sal21's Profile:
http://www.excelforum.com/member.php...fo&userid=2040
View this thread:
http://www.excelforum.com/showthread...hreadid=263300