View original (French)

How to automatically calculate days?

Solved
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

3 answers

  1.
    pijaku Posted messages 13513 Registration date   Status Moderator Last intervention   2 773
     
    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
    4
  2. Mike-31 Posted messages 18205 Registration date   Status Contributor Last intervention   5 147
     
    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.
    0
  3. Emi1004 Posted messages 2 Status Member
     
    A big thank you for your help, Franck.
    It works perfectly.

    Best regards,
    Emilie
    0