Forum Discussion

Ahmed_Ben_2021's avatar
Ahmed_Ben_2021
Copper Contributor
Oct 05, 2021
Solved

Calculating the number of months between two dates for survival analysis

Device: Mac  Excel product: Microsoft Excel for Mac / Version 16.53 (21091200) I am conducting survival analysis, and I want to calculate the survival time between the start and first events.  I f...
  • Riny_van_Eekelen's avatar
    Oct 05, 2021

    Ahmed_Ben_2021 What is "one month"? 28, 29, 30 or 31 days. I'd say an average month equals 365/12 days. Then, the third formula seems to be the best one.

Resources