I am trying to add 10 days to a "custom" date
Closed
realpple
Posts
2
Registration date
Sunday 12 October 2014
Status
Member
Last seen
13 October 2014
-
12 Oct 2014 à 13:36
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 14 Oct 2014 à 10:52
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 14 Oct 2014 à 10:52
Related:
- I am trying to add 10 days to a "custom" date
- Excel add days to date - Guide
- Ultimate custom night download - Download - Horror
- Custom resolution utility - Download - Customization
- Skype last seen days ago - Guide
- How to add a checkmark in word - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
13 Oct 2014 à 12:07
13 Oct 2014 à 12:07
Hi Realpple,
That is because you created a numerical string.
Create a date string by using d, m and y like:
ddVmmVyyyy
I used "V" because "\/" was turned into "/".
Best regards,
Trowa
That is because you created a numerical string.
Create a date string by using d, m and y like:
ddVmmVyyyy
I used "V" because "\/" was turned into "/".
Best regards,
Trowa
realpple
Posts
2
Registration date
Sunday 12 October 2014
Status
Member
Last seen
13 October 2014
13 Oct 2014 à 18:41
13 Oct 2014 à 18:41
Thank you, however I am trying to use a string that when the date is being entered you don't have to put in any dashes or slashes. Is it possible to add 10 days to the date like this? Maybe there is a different way I can format the date? and still do both of these actions?
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
14 Oct 2014 à 10:52
14 Oct 2014 à 10:52
Hi Realpple,
Consider this workaround:
Format cell A1 as text.
Now use a formula to change this value into a date:
=LEFT(A2,2)& "-" &MIDB(A2,3,2)& "-" & RIGHT(A2,4)
You can place this formula anywhere you want, in the next cell, out of sight, another sheet as long as you refer to the formula cell when adding the 10 days.
Best regards,
Trowa
Consider this workaround:
Format cell A1 as text.
Now use a formula to change this value into a date:
=LEFT(A2,2)& "-" &MIDB(A2,3,2)& "-" & RIGHT(A2,4)
You can place this formula anywhere you want, in the next cell, out of sight, another sheet as long as you refer to the formula cell when adding the 10 days.
Best regards,
Trowa
