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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 28, 2018 at 11:55 AM
Related:
- Adding days to dates
- Skype last seen days ago - Guide
- How to calculate 90 days from date in excel - Guide
- Move files older than x days windows - Guide
- How to recover spam mail after 30 days ✓ - Gmail Forum
- How to stop ads in gmail - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Aug 28, 2018 at 11:55 AM
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
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