Hai guys,
I have to prepare an excel sheet which resembles the 'Timesheet form
(seen in big companies which is to be filled by employees at the end o
month).user has to select the month and year first and then he has t
enter the total no.of hrs worked from day1 to end of month like this.
if he has selected say 'October' '2004'
date Hrs
-----------------
10/01/04 5
10/02/04 5
.......goes like this

here i have to validate in the excel sheet that if user has entere
wrong date or different month like 11/01/04, it has to display erro
message.
how i have to achieve this.....
plz help me
Thanks & regards,
Mahesh

--
itsmahesh
-----------------------------------------------------------------------
itsmaheshp's Profile: http://www.excelforum.com/member.php...fo&userid=1585
View this thread: http://www.excelforum.com/showthread.php?threadid=27353