Date re-formatting

[Adam]

I have data in mm/dd/yyyy format and was wondering how (or
if) I could convert that to just day of the year (1-365)?

thanks
adam

 

[Bob Phillips]

Adam,

Don't think you can reformat that cell, but you could calculate it in an
adjacent cell. All you need to do is subtract the last day of the previous
year from the date. For instance, if the date is in A1, use

=A1-DATE(YEAR(A1),1,0)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)