Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
validate date entered | Excel Worksheet Functions | |||
Need help with 52 worksheets that need dates entered | Excel Discussion (Misc queries) | |||
Dates not entered correctly | Excel Discussion (Misc queries) | |||
call excelsheet within excelsheet when user clicks excelsheet ico | Excel Worksheet Functions | |||
Validating Dates Entered | Excel Discussion (Misc queries) |