Previous Topic Next Topic

Adding days to dates

Closed
mlip Posts 1 Registration date Saturday August 25, 2018 Status Member Last seen August 25, 2018 - Aug 25, 2018 at 09:23 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 28, 2018 at 11:55 AM
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 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Aug 28, 2018 at 11:55 AM
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

Similar discussions

encryption message several time in chat
measking -
HelpiOS -

1 response
Can’t access settings for a few days lock out
Rak7 -
HelpiOS -

1 response
Ig stories from close friends to public
Darren -
zara -

31 responses
IF statements with dates and criteria
jimbabama -
Mazzaropi -

3 responses
You disagreed with the decision facebook
MDHamijuddin -
HelpiOS -

1 response