Forum Discussion

allieZ's avatar
allieZ
Copper Contributor
May 20, 2022
Solved

Auto populate same date, next coming year

Hello Excel Community!     I keep finding something SIMILAR to what I need, but not exactly.    I have a list of contract dates in oldest to newest order.  I need excel to automatically find the s...
  • mathetes's avatar
    May 20, 2022

    allieZ 

     

    Here's a quick and dirty formula. If you need something more sophisticated, come back with the details. A3 in this example is the prior contract end date.

    =IF(A3+365.25>TODAY(),A3+365.25,DATE(YEAR(TODAY()),MONTH(A3),DAY(A3)))

     

     

Resources