I am looking for a way to get the Month number and Day number given the number of days into a given year. I have a date code that I can capture that is 4 digits. The first digit is the year number, in the case of this year, it is 8. The next 3 digits are for the day of the year, for example 8030 would be January 30th, 2008 or 01/30/08. I figure there is some built in function that will allow me to decode 291 into whatever the 291st day of the year is, allowing for leap years.
Thanks in advance.