Forum Discussion
Ahmed_Ben_2021
Oct 05, 2021Copper Contributor
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...
- 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.
Riny_van_Eekelen
Oct 05, 2021Platinum Contributor
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.
Ahmed_Ben_2021
Oct 05, 2021Copper Contributor
Thank you, Riny
That was very helpful
That was very helpful