+ Reply to Thread
Results 1 to 3 of 3

Convert the number of weeks into years and months

  1. 05-16-2014, 11:48 AM #1
    Pickygame
    Pickygame is offline
    Registered User
    Join Date
    04-03-2009
    Location
    yorkshire
    MS-Off Ver
    Office 365
    Posts
    87

    Convert the number of weeks into years and months

    Hi

    I would like to convert a given number of weeks, say 76, into years and months. Can anyone help please?

    I can convert months by

    =INT(A1/12)
    =A1-12*INT(A1/12)

    Thanks

    Andy
    Reply With QuoteRegister To Reply
  2. 05-16-2014, 12:05 PM #2
    ConneXionLost
    ConneXionLost is offline
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Convert the number of weeks into years and months

    How about these:

    Years:
    Please Login or Register  to view this content.
    Months:
    Please Login or Register  to view this content.
    Cheers,
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.
    Reply With QuoteRegister To Reply
  3. 05-16-2014, 12:19 PM #3
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: Convert the number of weeks into years and months

    Assuming you have 76 in A1, then

    For Years
    Please Login or Register  to view this content.
    For Months
    Please Login or Register  to view this content.
    For Years & Months
    Please Login or Register  to view this content.
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Centering Years, Months, Weeks, or labels between X-Axis Tick Marks.
    By Cerbera79 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 09-21-2015, 08:31 AM
  2. [SOLVED] How to convert numeric number value to numeric years months
    By sonu_kumar444 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-16-2014, 03:06 AM
  3. Calculate Years, Months Weeks
    By mycon73 in forum Excel General
    Replies: 4
    Last Post: 03-02-2011, 12:02 PM
  4. [SOLVED] Convert Years to Years/Months/Days
    By [email protected] in forum Excel General
    Replies: 4
    Last Post: 01-04-2006, 11:00 AM
  5. [SOLVED] how do I convert a number to number of years, months and days
    By because in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-12-2005, 02:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1