i would like to show jan 1st is 1, or 8/2 is 214 ect whats the function?? thanks brad
B Brad Aug 2, 2007 #1 i would like to show jan 1st is 1, or 8/2 is 214 ect whats the function?? thanks brad
B Brad Aug 2, 2007 #3 Worked!!!! thank you Mike H said: Try this =A1-DATE(YEAR(A1),1,0) date in A1 and format as general Mike Click to expand...
Worked!!!! thank you Mike H said: Try this =A1-DATE(YEAR(A1),1,0) date in A1 and format as general Mike Click to expand...
