MSGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

error alert for invalid date

  • Follow


hi
I want excel showes error alert if user enters invalid dates like 
"2010/2/29"...
I can not creat it on  data validation.
0
Reply Utf 4/27/2010 9:11:01 AM 

Select the range..Say F1:F10

From Data>Validation>
--From Validation Criteria>Select 'Date' and mention the start date and end 
date..

--From Validation Criteria>Select 'Custom' and mention the below formula..
=DAY(F1)


-- 
Jacob (MVP - Excel)


"nader" wrote:

> hi
> I want excel showes error alert if user enters invalid dates like 
> "2010/2/29"...
> I can not creat it on  data validation.
0
Reply Utf 4/27/2010 9:20:01 AM 


it worked. thankes
best regards
nader

"Jacob Skaria" wrote:

> Select the range..Say F1:F10
> 
> From Data>Validation>
> --From Validation Criteria>Select 'Date' and mention the start date and end 
> date..
> 
> --From Validation Criteria>Select 'Custom' and mention the below formula..
> =DAY(F1)
> 
> 
> -- 
> Jacob (MVP - Excel)
> 
> 
> "nader" wrote:
> 
> > hi
> > I want excel showes error alert if user enters invalid dates like 
> > "2010/2/29"...
> > I can not creat it on  data validation.
0
Reply Utf 4/27/2010 10:51:01 AM
microsoft.public.excel.worksheet.functions 4936 articles. 39 followers.

2 Replies
339 Views

(page loaded in 0.286 seconds)

Similiar Articles:

error alert for invalid date - microsoft.public.excel.worksheet ...
hi I want excel showes error alert if user enters invalid dates like "2010/2/29"... I can not creat it on data validation. ...

calc. an anniversary date(50 years) after marriage date in excel ...
I need to be able to accurately calculate an anniversary date. For ... error alert for invalid date Utf 2 225

CRM invalid user errors - microsoft.public.crm
The user Id is invalid. - microsoft.public.crm Office 2010 - CRM - Invalid argument - microsoft.public.office ... error alert for invalid date - microsoft.public.excel ...

The user Id is invalid. - microsoft.public.crm
error alert for invalid date - microsoft.public.excel.worksheet ... Office 2010 - CRM ... Microsoft CRM Error Report: Error Description: The user Id is invalid. Error ...

Invalid Value types in Lookup field - microsoft.public.access ...
CDate will fail if it's presented with an invalid date ... I know it has to be ... the lookup > alert ... in a ..... you can run into following error: Invalid lookup ...

Before Update Event Undo problem - microsoft.public.access.forms ...
I suggest that you add an alert message that ... the offending text (or in this case a >date ... OK, it was the system error message in response to invalid data. which ...

Exception when using Notify User alerts in custom view - microsoft ...
Master Project Publishing Error + Alerts - microsoft ... The user Id is invalid. - microsoft.public.crm 0 ... Sending Email alerts before expire date on document (using ...

SBS 2008 and Exchange 2007 - microsoft.public.windows.server.sbs ...
On Sunday I started getting alerts ... System Attendant Mailbox Date: 5/24/2010 9:30:43 AM Event ID: 4001 Task Category: General Level: Error ...

re: Windows mail problem - microsoft.public.windows.vista.mail ...
Hi - This is the error message I've been getting. ... mail Filter [July 2010] (KB905866) Installation date ... net', Protocol: > POP3, Server Response: '-ERR invalid ...

CRM Error: General failure in scheduling engine - microsoft.public ...
I get this error: ERROR: Invalid Argument/Option ... engine - Tech Stack Join Date Aug 2010 Posts 0. CRM Error: General ... Scheduling Alerts. recieve error message "General ...

error alert for invalid date - microsoft.public.excel.worksheet ...
hi I want excel showes error alert if user enters invalid dates like "2010/2/29"... I can not creat it on data validation. ...

Warning Javascript Window Invalid Format Date - JavaScript Window
Warning Javascript Window Invalid Format Date ... Javascript Window Alerts. Q:How do I embed ... Short error: Invalid account activity begin date.

parse Method - Website Development & Promotion Tools and Services
For example, "23:15 PM" is an error. A string containing an invalid date is an error. ... s += "between " + testdate + " and 1/1/70"; return(s);} alert ...

Invalid Date format Error: date, format - Experts Exchange - Your ...
Invalid Date format Error ... convert date to YYYYMMDD format; Ora Error messages alert; SQL Err To_char: ORA-01722…

Excel -Data Validation Messages for Users
a) Click on the Error Alert tab to activate it b) Add a check mark to the Show error alert after invalid data is entered box.

7/31/2012 7:42:46 AM


Reply:



Privacy Policy | All Times Are GMT(UTC) | powered by