Follow up Q to how to add a certain number of days to a date in excel
Closed
Izanagi7
-
Jul 4, 2019 at 09:44 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 8, 2019 at 11:35 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 8, 2019 at 11:35 AM
Related:
- Follow up Q to how to add a certain number of days to a date in excel
- How to add 90 days to a date in excel - Guide
- Number to words in excel - Guide
- How to add @ in laptop - Guide
- Pdf and xps add in 2007 - Download - Other
- How to add a tick in word - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Jul 8, 2019 at 11:35 AM
Jul 8, 2019 at 11:35 AM
Hi Izanagi,
Not entirely sure I fully understand you.
Let's try a formula first.
This is how I imagined your request:
In column A you have dates. When 12 columns or less contain data, you want to add 14 days to the date in column A and place the new date in column B.
Formula in B2:
=IF(M2="",A2+14,"")
When column M contains data, more then 12 columns are used and column B remains empty.
Best regards,
Trowa
Not entirely sure I fully understand you.
Let's try a formula first.
This is how I imagined your request:
In column A you have dates. When 12 columns or less contain data, you want to add 14 days to the date in column A and place the new date in column B.
Formula in B2:
=IF(M2="",A2+14,"")
When column M contains data, more then 12 columns are used and column B remains empty.
Best regards,
Trowa