Results 1 to 14 of 14

Calculate birthday and age as if there were 112 days in a year

Threaded View

  1. #13
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,786

    Re: Calculate birthday and age as if there were 112 days in a year

    Yes, I think you need a semi-colon separator instead of the comma, i.e. in Portuguese

    =INT((HOJE()-N3)/112) &" years and "& MOD(HOJE()-N3;112) &" days"

    See attached
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculate age if there were 112 days in a year
    By army in forum Excel General
    Replies: 7
    Last Post: 12-09-2014, 04:59 PM
  2. Calculate amount of days per year within range
    By constructionbart in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-20-2014, 05:24 AM
  3. Calculate points for year based on last 180 days
    By Diogie in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-08-2013, 04:01 PM
  4. Convert a multiple year list of 365 days/year into an equivalent of 360 days/year
    By lobotomy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-24-2012, 05:39 PM
  5. Calculate Year Month and Days and Add them
    By lavan_joy in forum Excel General
    Replies: 8
    Last Post: 11-17-2010, 12:35 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1