|
Posted to microsoft.public.excel.misc
|
|
|
Is there a way to identify saturday and sunday automatically
Try:
=OR(WEEKDAY(A1)=1,WEEKDAY(A1)=7)
HTH
JG
--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=498354
|