Adding days to dates [Closed]

Report
Posts
2
Registration date
Saturday August 25, 2018
Status
Member
Last seen
August 25, 2018
-
Posts
2656
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 17, 2020
-
Hello,

I was hoping someone could help with this, I am creating a spreadsheet and am having problems with the following:

Column D shows Date Enrolled, Column E shows Experience (options are more than 1 year or Less than 1 year in a drop down menu) I would like column F to add 35 days if "Less than 1 year" and 21 days if "More than 1 year" is selected.

Any help would be greatly appreciated, Please and Thank You

1 reply

Posts
2656
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 17, 2020
440
Hi Mlip,

The following nested IF formula will do as requested:
=IF(E2="Less than 1 year",D2+35,IF(E2="More than 1 year",D2+21,D2))

Best regards,
Trowa