Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    London, Gtr London, England
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts

    partial date in formatted cell (2002)

    I keep track of when forms arrive in the office, by having a row for each student, and columns for the date of arrival. I format the cell to show the date in 31/12/2000 format, but sometimes I need to put a partial date in for example if I dont know the full date, excel dosent like this and gives a full date, which is always wrong. I want to be able to put in say just the year, and have it display the four digit year only. Can this be done? TiA

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: partial date in formatted cell (2002)

    One option is to always enter a full date, for example:
    Enter 01/12/2005 for December 2005 and format as mm/yyyy
    Enter 01/01/2005 for 2005 and format as yyyy

    Another option is to enter incomplete dates as text values, prefixing them with an apostrophe:
    Enter '12/2005 for December 2005
    Enter '2005 for 2005
    Excel will not display the apostrophe in the cells, only in the formula bar.
    Since these values are text, you cannot use them directly in calculations.

  3. #3
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    London, Gtr London, England
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: partial date in formatted cell (2002)

    Thank you, a great answer. Your second solution is the one for me to use, calculations on dates only apply when the actual date is known, I just need a reminder that something is due in say August, or in Spring 2007. Using text for this is ideal. When the true date is known, I can then enter it with the full date format needed for calculating.

Posting Permissions

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