hi all!

i am updating a worksheet on daily basis and one of the cell is having
the formula =(TODAY()-1), since i am updating the figures of the
earlier day!
what i want is when i am opening the file on Monday as well as on any
other day immediately following a holiday (will be defined by me) the
cell should automatically skip the "Sunday" and the other "Holidays"!!

hlp pl!!

-via135


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=514997