Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Mechanicsville, Virginia, USA
    Posts
    130
    Thanks
    0
    Thanked 0 Times in 0 Posts

    First of Year formula (Excel 2003)

    Morning!

    I am hoping that someone can provide me with a formula that will provide the first date in the year. I am looking for a formula that will look at a certain cell and provide that information.

    I appreciate your assistance!

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

    Re: First of Year formula (Excel 2003)

    Say that you have a date in cell A1.
    The formula =DATE(YEAR(A1),1,1) placed in another cell will return the first day of the year of that date.

    Note: if you simply want the first day of the current year, use =DATE(YEAR(TODAY()),1,1)

  3. #3
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Mechanicsville, Virginia, USA
    Posts
    130
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: First of Year formula (Excel 2003)

    Thanks Hans!

Posting Permissions

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