Join us June 17–18 for a deep dive into Copilot Control System—live expert-led sessions and Q&A on data security, agent lifecycle, adoption, and more! Learn more >

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 question in what day and month will be the 35th day of this 334 days ?

Please help..??

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

2 Replies

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.

Resources