Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Calculating Child's Age - off by one day
Thank you for your replies. I am trying the DAYS360, but I need to know the exact number of years, months and days. I cannot use 7.5 for 7 months and ... days. And yes, the standardized tests require we use the 30 days/4 weeks constraint, but some round up and some do not. So for some tests...- SDLevy
- Post #6
- Forum: Microsoft: Office
-
Calculating Child's Age - off by one day
We do standardized tests on children evaluate for developmental delay. I am trying to set up an excel form to calculate the chronological age - the tests assume that each month has 30 days and 4 weeks. I tried the calculation from MS resource page and am off by one day for some children. Any...- SDLevy
- Thread
- Replies: 5
- Forum: Microsoft: Office
