SOLVED

Number to Date and Month

Iron 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 (Iron Contributor)
Solution

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

=A1+(A2-A1)/2

 

And for the other example:

=A1+35

Actually i try to calculated the numbers of days.
=A1+(A2-A1)/2
is work..
Thank you so much sir.
1 best response

Accepted Solutions
best response confirmed by Excel (Iron Contributor)
Solution

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

=A1+(A2-A1)/2

 

And for the other example:

=A1+35

View solution in original post