gymwrecker
Active Member
- Joined
- Apr 24, 2002
- Messages
- 396
- Office Version
- 365
- Platform
- Windows
- MacOS
Team,
I'm working with "Net Periods of Service" and need a formula that converts days into months and years, and/or months into years. For instance, this is what I have: Note: Using MS Excel 2016 (MAC Version)
Net Active this period
YRS MO DAYS
DD214 Separation Date 2 3 15
DD214 Separation Date 4 3 22
DD214 Separation Date 6 33 20
DD214 Separation Date 2 10 2
DD214 Separation Date 1 3 30
DD214 Separation Date 1 10 28
TOTAL 16YRS 62MO 117DAYS
SOLUTION: NET TOTAL 21YRS 4MO 9DAYS (Need a formula to obtain this using the above totals)
How can I convert the 177 days into months, and the 62 months into years?
I'm working with "Net Periods of Service" and need a formula that converts days into months and years, and/or months into years. For instance, this is what I have: Note: Using MS Excel 2016 (MAC Version)
Net Active this period
YRS MO DAYS
DD214 Separation Date 2 3 15
DD214 Separation Date 4 3 22
DD214 Separation Date 6 33 20
DD214 Separation Date 2 10 2
DD214 Separation Date 1 3 30
DD214 Separation Date 1 10 28
TOTAL 16YRS 62MO 117DAYS
SOLUTION: NET TOTAL 21YRS 4MO 9DAYS (Need a formula to obtain this using the above totals)
How can I convert the 177 days into months, and the 62 months into years?
Last edited: