Another question regarding Dates..

[Guest]

First, thanks to the replies to my previous post.

How can I work out the day & month when I only know the Year and Day Number?

Ie

Year = 2004
day number = 302

The answer I'm looking for is 28/10/2004

Again, taking into consideration the leap years

Thanks again in advance

 

[Guest]

=DATE(2004,1,302)


Regards,

Peo Sjoblom

 

[Guest]

Thanks, it worked a treat...

=DATE(2004,1,302)


Regards,

Peo Sjoblom