Number to Date and Month

Super Contributor

Hello Everyone, 

I calculate half of 334 that is 167 i would like to know in what day and month the day 167 will be. I mean in 167 day out of 334 days in what date it will be. Another example of the question in what day and month will be the 35th day of this 334 days ?


Annotation 2022-12-19 182116.png


Please help..??

2 Replies
best response confirmed by Excel (Super Contributor)

@Excel For your first example, wouldn't this work?



And for the other example:


Actually i try to calculated the numbers of days.
is work..
Thank you so much sir.