Date number to date conversion

[jamesa123]

is it possible to convert a excel value from date number to date via vba or formula where the input is 1 to 365 and leap year 366 to a output of month and date number for example 104 as date number and date for 2023 will be april 14. i couldnt figure out how so i haveno code to start with whatsoever

 

[Joe4]

Let's say that we have 104 in cell A1 and 2023 in cell A2.
Then use this formula:

=DATE(A2,1,1)+A1-1

 

[Phuoc]

Or try this

=DATE(A2,1,A1)

 

[snjpverma]

Or try this

=DATE(A2,1,A1)

Nice one. I didn't know the months get adjusted with this trick