+ Reply to Thread
Results 1 to 2 of 2

When February 29 is date?

  1. #1
    jj4446
    Guest

    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. #2
    vezerid
    Guest

    Re: 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1