Validate dates entered in excelsheet
 

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

Validate dates entered in excelsheet
 

Hi
use 'Data - Validation - Date' for this

"itsmaheshp" wrote:


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 of
month).user has to select the month and year first and then he has to
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 entered
wrong date or different month like 11/01/04, it has to display error
message.
how i have to achieve this.....
plz help me
Thanks & regards,
Mahesh P


--
itsmaheshp
------------------------------------------------------------------------
itsmaheshp's Profile: http://www.excelforum.com/member.php...o&userid=15859
View this thread: http://www.excelforum.com/showthread...hreadid=273530