How to automatically calculate days?
Solved
Emi1004
Posted messages
2
Status
Member
-
Emi1004 Posted messages 2 Status Member -
Emi1004 Posted messages 2 Status Member -
Hello,
I would like to create an Excel (2003) file that displays the number of accident-free days at a workplace.
Is there a function that would allow me to automatically add a day if no accidents occur? This would avoid the need for a manual update of this file...
Thank you in advance for your help.
Emilie
I would like to create an Excel (2003) file that displays the number of accident-free days at a workplace.
Is there a function that would allow me to automatically add a day if no accidents occur? This would avoid the need for a manual update of this file...
Thank you in advance for your help.
Emilie
3 answers
Hello,
Let's assume that in D7 of your sheet you have the date of the last accident.
In D8, if you want the number of days, to today, without accidents:
=TODAY()-D7
Be careful, you need to format your cell as a number:
Right click / cell format / "Number" tab, choose the "number" category with number of decimals = 0
--
Best regards,
Franck P
Let's assume that in D7 of your sheet you have the date of the last accident.
In D8, if you want the number of days, to today, without accidents:
=TODAY()-D7
Be careful, you need to format your cell as a number:
Right click / cell format / "Number" tab, choose the "number" category with number of decimals = 0
--
Best regards,
Franck P
Hi,
Yes, of course, it is possible to write a formula, but we need more information about the structure of your file
how does your file work, I imagine that in one column you have dates and that these dates in relation to today are used to calculate a number of days without accident and therefore allow you to add days, if that’s the case, after how many days without accident do you add 1 day
A+
Mike-31
A period of failure is a perfect time to sow the seeds of knowledge.
Yes, of course, it is possible to write a formula, but we need more information about the structure of your file
how does your file work, I imagine that in one column you have dates and that these dates in relation to today are used to calculate a number of days without accident and therefore allow you to add days, if that’s the case, after how many days without accident do you add 1 day
A+
Mike-31
A period of failure is a perfect time to sow the seeds of knowledge.