Formula to increment date by seven days.
Solved/Closed
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
-
Sep 25, 2014 at 09:22 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Sep 26, 2014 at 03:07 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Sep 26, 2014 at 03:07 AM
Related:
- Formula to increment date by seven days.
- Date formula in excel dd/mm/yyyy - Guide
- How to calculate 90 days from date in excel - Guide
- Skype last seen days ago - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Number to words in excel formula - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
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
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
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.