Formula to add on year

=[Contract Start Date]1 + YEARDAY()

Looking for a formula that automatically calculates one year from the contract start date


  • L_123
    L_123 ✭✭✭✭✭✭

    The simplest is

    =[Contract Start Date]@row +365

    The most correct is

    =date(year([Contract Start Date]@row)+1,month([Contract Start Date]@row),day([Contract Start Date]@row

    The simpler formula will be a single day off on leap years, while leap years won't effect the second one