Forum Discussion

Iron Contributor

Dec 19, 2022

Solved

Number to Date and Month

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...

excel

Formulas and Functions

Riny_van_Eekelen
Dec 19, 2022
Excel For your first example, wouldn't this work?
=A1+(A2-A1)/2

And for the other example:
=A1+35

Riny_van_Eekelen

Platinum Contributor

Dec 19, 2022

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

=A1+(A2-A1)/2

And for the other example:

=A1+35

Excel

Iron Contributor

Dec 19, 2022

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