I am wanting to calculate both: the difference between two dates (lets say “A” and “B”) and be able to enter a number of days and have that be added to the original date (A):


 So If I enter a date in column A(12/1/2014) and in B (12/20/2014), I want C to show me the difference in days (19). If I enter a date in A(12/1/2014) and number of days in C(19), I want B to auto populate as the if it they were added together(12/20/2014). 


It would also be nice if B wasn’t automatically entered it just autopopulate to “TODAY” so the number of days “C” would automatically add “1” each day.

By: Jessica

Leave a Reply

Your email address will not be published. Required fields are marked *