Dave Cobb

Posts: n/a

Converting number of days to years and months

I want to convert the number of days in a cell (ie: 2350) to Xyears and
Ymonths. What formula to use?

Thanks,
Dave

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Number of years, months, days between two dates.	Bluenose	Excel Worksheet Functions	34	June 30th 05 02:18 PM
difference between two dates in years, months and days.	ruby	Excel Worksheet Functions	2	April 4th 05 04:51 PM
Where is DateDiff function in Excel 2002 ?	Nigel Welch	Excel Worksheet Functions	4	March 4th 05 03:18 PM
converting months to years and months???	Marty	Excel Discussion (Misc queries)	1	February 18th 05 02:38 AM
Converting months to years	kevin	Excel Worksheet Functions	1	January 20th 05 01:28 PM

All times are GMT +1. The time now is 05:24 PM.

About Us

"It's about Microsoft Excel"