Formula to increment date by seven days.
Solved/Closed
vcoolio
Posts
1364
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 10, 2023
-
Sep 25, 2014 at 09:22 AM
vcoolio Posts 1364 Registration date Thursday July 24, 2014 Status Moderator Last seen February 10, 2023 - Sep 26, 2014 at 03:07 AM
vcoolio Posts 1364 Registration date Thursday July 24, 2014 Status Moderator Last seen February 10, 2023 - Sep 26, 2014 at 03:07 AM
Related:
- Formula to increment date by seven days.
- Excel if statement increment by 1 - Guide
- 1st, 2nd, 3rd position formula in excel ✓ - Office Software Forum
- You only have 30 days left to request a review. after that your account will be permanently disabled ✓ - Facebook Forum
- Skype last seen days ago - Guide
- How to add days to a date in excel - Guide
2 replies
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
545
Sep 25, 2014 at 11:25 AM
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
Posts
1364
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 10, 2023
252
Sep 26, 2014 at 03:07 AM
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.