Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jj4446
 
Posts: n/a
Default When February 29 is date?

I'm entering dates for birthdays and anniversaries, how do I get them to put
the data into the cell as I'm typing it; i.e., Jul 10; and also, I have a
birthday of February 29, how is this typed in so the configuration doesn't
change the date to something else?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid
 
Posts: n/a
Default When February 29 is date?

When you enter a date only as month/day, excel interprets it as a date
of the current year. If you later click on such a cell and view the
formula bar, you will see that excel has added the current year.

If you enter a Feb 29 of a leap year then it will be correctly entered
as date, otherwise it will become text.

If you want to be consistent you could enter the dates with the birth
year included, unless this information is too sensitive for some of
your peers :)

HTH
Kostis Vezerides

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
How do I create a schedule from a list of dates ? Gavin Morris Charts and Charting in Excel 2 October 28th 10 04:08 PM
Adding XY days to date in cells satucha Excel Discussion (Misc queries) 1 November 25th 05 08:02 AM
Another Date issue. TimM Excel Worksheet Functions 1 November 17th 05 01:58 AM
date and time ladimples247 New Users to Excel 2 February 16th 05 08:52 PM
Need help troubleshooting an array formula XLXP on Win2K KR Excel Worksheet Functions 1 December 13th 04 07:41 PM


All times are GMT +1. The time now is 07:16 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"