thks both of you Pete & Smith!
but.. using a holiday range would even better??!!
-via135
Fred Smith Wrote:
I can help you out on the Mondays.
=today()-if(mod(today()-2,7)=0,3,1)
will return Friday if today is a Monday, else the previous day.
For holidays, you'll probably have to build a table and use Lookup or
Match.
--
Regards,
Fred
"via135" wrote in
message
...
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
--
via135
------------------------------------------------------------------------
via135's Profile:
http://www.excelforum.com/member.php...o&userid=26725
View this thread:
http://www.excelforum.com/showthread...hreadid=514997