Results 1 to 4 of 4

Convert a day date to a year

Threaded View

  1. #1
    Registered User
    Join Date
    07-25-2008
    Location
    Wales
    MS-Off Ver
    2007
    Posts
    64

    Convert a day date to a year

    Hi all,

    ..had a prblem recently which was resolverd regading making a series of "day" dates into a month...now have the same problem with years!

    I have a spreadsheet with "standard" date entry..ie dd/mm/yy. But I want to creat a column that will just show a year.

    ie I know that I can format it by "yyyy", but I only want the cell info to give me the same "day" for each year.

    eg
    01/03/09 = 01/01/09 = 2009
    04/06/09 = 01/01/09 = 2009

    any help gratefully received.....

    Stu
    Last edited by Stu100; 03-09-2010 at 09:18 AM.

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