=CHOOSE(WEEKDAY(CONCATENATE(day,"/",month,"/",year)),"Sunday","Monday","Tuesday","Wednesday"," Thursday","Friday","Saturday")
try this
where day is put a cell value
where month is put a cell value
where year is put a cell value
try this
--
Zygan
------------------------------------------------------------------------
Zygan's Profile:
http://www.excelforum.com/member.php...o&userid=34423
View this thread:
http://www.excelforum.com/showthread...hreadid=560647