I am trying to add 10 days to a "custom" date [Closed]

Report
Posts
2
Registration date
Sunday October 12, 2014
Status
Member
Last seen
October 13, 2014
-
Posts
2693
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 18, 2021
-
In the original cell I am using a custom date format of 00\/00\/0000 and in another cell I am adding 10 days to the date with the simple formula C1+10 but it is adding the 10 days to the year not the day.... Any help is greatly appreciated. Thanks!

2 replies

Posts
2693
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 18, 2021
455
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
Posts
2
Registration date
Sunday October 12, 2014
Status
Member
Last seen
October 13, 2014

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?
Posts
2693
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 18, 2021
455
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!