we have a date code that gives the year and the day number, for example 04270. My question is how do i find out what the exact date is if all i have is the numeric value of the day for any given year?
That's the hint i needed, but with the Date function, I think i have to convert the year into a 4 digit year because the function works off the 1900 date system and the two digit one that i have comes back with 1904 if i have 04...but that's nothing, thanks for the concept!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.