Edate

%3CLINGO-SUB%20id%3D%22lingo-sub-1929734%22%20slang%3D%22en-US%22%3EEdate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1929734%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20newsletters%20that%20are%20renewed%20each%20year%20if%20the%20customer%20has%20paid.%26nbsp%3B%20I%20am%20trying%20to%20set%20up%20a%20formula%20that%20says%20if%20cell%20(x)%20%3D%20Y%20then%20move%20the%20date%20in%20cell%20(y)%20forward%20a%20year.%26nbsp%3B%20I%20am%20struggling%20to%20get%20this%20to%20work%20would%20anyone%20know%20how%20to%20do%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1929734%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1929789%22%20slang%3D%22en-US%22%3ERe%3A%20Edate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1929789%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F881082%22%20target%3D%22_blank%22%3E%40Hrdevelop45%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20general%20that%20is%20job%20for%20VBA%20programming.%20There%20is%20the%20trick%20to%20use%20formulas%20enabling%20iterative%20calculations%2C%20first%20sample%20I%20found%20is%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fhowtoexcelatexcel.com%2Fexcel-tips-tricks%2Fcreate-a-timestamp-in-excel-with-formulas%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3ECreate%20A%20Timestamp%20In%20Excel%20With%20Formulas%20-%20How%20To%20Excel%20At%20Excel%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

We have newsletters that are renewed each year if the customer has paid.  I am trying to set up a formula that says if cell (x) = Y then move the date in cell (y) forward a year.  I am struggling to get this to work would anyone know how to do this?

2 Replies

@Hrdevelop45 

In general that is job for VBA programming. There is the trick to use formulas enabling iterative calculations, first sample I found is Create A Timestamp In Excel With Formulas - How To Excel At Excel 

@Sergei Baklan thank you I will take a look.