Excel formula help please

Poodle
Poodle Registered Posts: 695 Epic contributor 🐘
edited June 18 in AAT member discussion
Just cannot remember the formula, a sign of age i guess.

I want to put a date into cell A1

and in A2 I want a formula to add on a date 6 months and 10 days after the date in A1

Thanks

Julia

Comments

  • burg
    burg Registered, Moderator Posts: 1,425 mod
    I'm sure there are a few ways but I use

    =DATE(YEAR(A1),MONTH(A1)+6,DAY(A1)+10)
    Regards,

    Burg
  • oakley
    oakley Registered Posts: 73 Regular contributor ⭐
    format cells A1 and A2 to date
    Enter date eg 01/01/2009 in cell A1
    enter +A1+190 in cell A2
    answer = 10/07/2009
  • blobbyh
    blobbyh Registered Posts: 2,340 Beyond epic contributor 🧙‍♂️
    If you expand on Burg's formula by having separate input boxes for 'Month' and 'Day', you can quickly find the date of anything you want by entering months, days or a combination of both.

    Target cell formula "=DATE(YEAR(A3),MONTH(A3)+B7,DAY(A3)+D7)"

    A3 - the start date
    B7 - the number of months
    D7 - the number of days
  • Poodle
    Poodle Registered Posts: 695 Epic contributor 🐘
    Thanks as always

Categories

Privacy Policy