Prev Previous Post   Next Post Next
  #7   Report Post  
Carlos Antenna
 
Posts: n/a
Default

1) Select the cell or range of cells you want to restrict.
2) Pull down the Data menu.
3) Choose Validation...
4) Settings Tab, Allow: Date, Data: Greater than or equal to , Start Date:
1/1/2005
5) Error Alert Tab, Error message: It's 2005, Dummy.
6) OK button
7) Check behavior by entering good and bad dates.

Carlos

"Charlene" wrote in message
...
Carlos, thank you, that is exactly what I want to do, but I don't know how
to
do it. Can you help?

"CarlosAntenna" wrote:

Use data validation to restrict the entry to dates greater than or
equal
to 1/1/2005.

Carlos

"Charlene" wrote in message
...
thank you for your reply Harald, but I don't think I explained myself
very
well.

My employees use Excel to enter timesheet info. If they accidentially

enter
the year 2004 instead of 2005, is there a way Excel can automatically

change
the year to 2005?

"Harald Staff" wrote:

Hi

With the date of your birth in cell A1, this formula in another cell

will
return this year's birthday:
=DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))

HTH. best wishes Harald

"Charlene" skrev i melding
...
How can I make a cell correct the year of a date








 
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 updates from worksheet to chart & changes date to a date series! Help!! Jayjg Charts and Charting in Excel 2 January 22nd 05 03:00 PM
How do I stop today() from updating date on saved spreadsheets? lionmark Excel Discussion (Misc queries) 2 January 4th 05 01:03 AM
Date formula Robyn Bellanger Excel Discussion (Misc queries) 2 December 16th 04 12:41 AM
Problem with Date format from VBA code twig Excel Discussion (Misc queries) 3 December 7th 04 06:01 PM
How do I convert a Julian date into a regular date? Jessica Excel Discussion (Misc queries) 4 December 2nd 04 02:54 AM


All times are GMT +1. The time now is 12:19 AM.

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"