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