Convert 1 day to integer as 1 ?

Hello I use numbers sheet as financial budget, would like to know how many incomes I need in the semester.

For this case I use Today function and closing date as well Days to end = closing date - today

This give me a result as 134 days but can't divide an amount in euros in days. For instance 10.000€ / 134 days give a 98,56 number that do not have any sense. How I can converter 134 d in integer 134 ?


Thank you in advance

MacBook Pro 15″, macOS 12.7

Posted on Oct 17, 2023 7:23 AM

Reply
2 replies

Oct 17, 2023 7:39 AM in response to Recycleur

Thank you is useful your answer, I see that STRIPDURATION returns an integer and works. But return me the same strange number 98,56 until I discover that the alienation of the cell was on the middle and always seeing part of the number.

As I did before 134d can manage already as an integer, whatever thank you very much for helping and fast reply.


Convert 1 day to integer as 1 ?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.