It may be a throwback to my dinosaur age. Or, maybe an extra round of tequila the day before?!?! But... It was a method that I selected to pad out the month and day with a "0". Cleaner is always better. Easier to audit, as well. Good advice, thanks.
More important than that, I was trying to figure out why my Excel was considering the source in the original date if it was found to the right of my first column in a named range when used with a "sumif" function. I know it did not work, as I witnessed the double value, but, was wondering if anyone had also experienced that hiccup, and if there was a correction to the value error kicked out.
The source spreadsheet was extracted (exported) into Excel from a google docs spreadsheet entry. ...If that matters in this quest for understanding.
Yours in spreadsheets,