Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,886
Default Data Validation for a date

Hi

Glad we got there in the end. Thanks for the feedback.

--
Regards

Roger Govier


"mgkaam" wrote in message
...
Thank you so much that worked perfectly!

"mgkaam" wrote:

I have a column that people will enter any date in this format
01/01/07, I
need to validate that if this date is older than 60 days from Today's
date
than it will give me an error. What kind of formula would I need to
achieve
this? I have to do this for 50 rows in the same column.

Thanks,



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date data not viewed as Date? Jugglertwo Excel Discussion (Misc queries) 1 December 21st 06 07:05 PM
Mileage Claim Formula johndavies New Users to Excel 4 August 14th 06 09:24 AM
Inputting data to one worksheet for it effect another daedalus1 Excel Discussion (Misc queries) 1 June 25th 06 04:39 PM
ranking query JaimeTimbrell Excel Discussion (Misc queries) 2 February 16th 06 08:09 AM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM


All times are GMT +1. The time now is 03:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"