Formula to increment date by seven days.
Solved/Closed
vcoolio
vcoolio
- Posts
- 1345
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- May 20, 2022
vcoolio
- Posts
- 1345
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- May 20, 2022
Related:
- Formula to increment date by seven days.
- Excel formula to increment cell value by 1 ✓ - Forum - Excel
- Formula to add big number of day to date in excel sheet ✓ - Forum - Excel
- Excel formula to calculate 90 days from a specific date - Guide
- Excel day month year formula - Guide
- Excel formula - Add days to date based on drop down selection ✓ - Forum - Excel
2 replies
TrowaD
Sep 25, 2014 at 11:25 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Sep 25, 2014 at 11:25 AM
Hi Vcoolio,
Sure, no problem!
=IF(A1="","",A1+7)
If A1 is empty, show nothing.
If A1 is not empty, then add 7 to it.
Best regards,
Trowa
Sure, no problem!
=IF(A1="","",A1+7)
If A1 is empty, show nothing.
If A1 is not empty, then add 7 to it.
Best regards,
Trowa
vcoolio
Sep 26, 2014 at 03:07 AM
- Posts
- 1345
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- May 20, 2022
Sep 26, 2014 at 03:07 AM
Hello again Trowa,
Thanks for that. Much appreciated.
This is actually another of the wife's projects so you've saved me from the dog house again!
After posting the thread, I played around with formulas (formulae?) for about an hour and found that the following ISBLANK function works well also:-
=IF(ISBLANK(A1),"",A1+7)
but I like your formula better so I've inserted it to replace the ISBLANK one.
I can't believe how lazy the wife and I have become (can't even type in a date a few columns away)!!
BTW, thanks for explaining the formula also.
Anyway, grazie molto.
vcoolio.
Thanks for that. Much appreciated.
This is actually another of the wife's projects so you've saved me from the dog house again!
After posting the thread, I played around with formulas (formulae?) for about an hour and found that the following ISBLANK function works well also:-
=IF(ISBLANK(A1),"",A1+7)
but I like your formula better so I've inserted it to replace the ISBLANK one.
I can't believe how lazy the wife and I have become (can't even type in a date a few columns away)!!
BTW, thanks for explaining the formula also.
Anyway, grazie molto.
vcoolio.