HOW DO I CHANGE DATES AUTOMATICALLY IN EXCEL

Closed
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

Any clever person out there.

I am a frustrated administrator.

I need to forward plan with dates. Basically I enter a Date of Birth in one column (Column C) format DD/MM/YYYY I need to automatically update into another column (Column F) a date which is this date of birth plus 14 days, and in another column (Column H) this date of birth plus 6 weeks? Is there a formula which will automatically calculate these dates every time I enter date of birth?



1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Why would any clever person be wasting his time over here ?

having said that, you can use formula

Lets say you enter that data in cell C1
then in f1 you can have

=IF(C1<>"", C1+14, "")

and in H1
=IF(C1<>"", C1+(6 *7), "")