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!
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?