Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    386
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Fill anniversary dates

    I would like to fill anniversary dates (year)using the fill feature in Excel

    Attached is a sample worksheet of what I would like to accomplish.

    Thank you.
    Attached Files Attached Files

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Enter the first 2 numbers, select them, then drag at the bottom right corner...

    Steve

  3. #3
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,633
    Thanks
    115
    Thanked 647 Times in 590 Posts
    If that does not work, In your example, enter in cell A9

    =DATE(YEAR(A8)+1,MONTH(A8),DAY(A8))

    And copy down using the fill feature

    Maud

Posting Permissions

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