Notifications
Clear all
General Excel Questions & Answers
4
Posts
3
Users
0
Reactions
68
Views
Topic starter
Hello,
I have two columns I need to create a date from. [Year] and [Day of Year]
I guess the tricky part for me is converting a day number to month and date. Thank you for your help!
Posted : 15/01/2022 10:43 am
Hi Adam
If your Year is in A1 and the Day of Year in B1 you can use this
=DATEVALUE(A1&"/1/1")+B1-1
Regards
Phil
Posted : 16/01/2022 12:53 am
You could also use:
=DATE(A1,1,B1)
Posted : 18/01/2022 8:19 am
Topic starter
Thank you Phil, that was exactly what I was hoping for!
Posted : 18/01/2022 10:50 am
