Age with =INT((E2-B2)/365) says Ben is 41. He is 40: his birthday is 3 days away, and leap days push the result over. =DATEDIF(B2,E2,"y") counts complete years -> 40.
Age with =INT((E2-B2)/365) says Ben is 41. He is 40: his birthday is 3 days away, and leap days push the result over. =DATEDIF(B2,E2,"y") counts complete years -> 40.
0 vue
Publié le 22/11/2026 02:00
Age with =INT((E2-B2)/365) says Ben is 41. He is 40: his birthday is 3 days away, and leap days push the result over. =DATEDIF(B2,E2,"y") counts complete years -> 40.
1 commentaire
?
T
Full guide: cellwise.app/guides/calc...