Formula to change certain Dates

Leonie Muller

Hi I am in need of some urgent help.  When the date paid has been changed I want the Company Review date to change by a Full Year and the once that has change I want the due date to change by 2mths.

 

It would be much appreciated if someone could please help me out.

 

Paul Newcome

Are you able to provide some screenshots with sensitive/confidential data hidden or replaced with "dummy data"?

 

Just based on your post I would think that entering this into the Company Review Date

 

=[Date Paid]@row + 365

 

and this in the due date field

 

=[Company Review]@row + 60

 

Should be a good start.