Mission Impossible

[sal21]

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

 

[Frank Kabel]

Hi
have a look at the WORKDAY function