Results 1 to 5 of 5

How to Calculate Age In 1-July-2016

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,146

    How to Calculate Age In 1-July-2016

    hi all..

    i have formula to calculate age of students cut off per 1 july 2016

    this formula working in 2015 but not working in 2016, how to fix it 2016, 2017, etc...

    =INT(DATEDIF(L26;--"01-JUL-2015";"M")/12)&" tahun "&ROUND(MOD(DATEDIF(L26;--"01-JUL-2015";"M")/12;1)*12;2)&" bulan"
    how to modified well..

    any helps, thanks in advance..

    john mustofa
    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. Call in the Cavalry - 2016
    By JBeaucaire in forum The Water Cooler
    Replies: 147
    Last Post: 01-10-2017, 12:36 PM
  2. Excel 2016 & beyond!
    By jewelsharma in forum The Water Cooler
    Replies: 6
    Last Post: 01-10-2016, 05:53 AM
  3. Excel 2016 Problem
    By lgchandana in forum Excel General
    Replies: 4
    Last Post: 12-16-2015, 06:07 AM
  4. Powerpivot in excel 2016
    By Poperick in forum Office 365
    Replies: 0
    Last Post: 10-19-2015, 07:03 AM
  5. Will it be a bug inside Word 2016 ?
    By neu_stone in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-29-2015, 11:54 AM
  6. Will it be a bug inside Word 2016 ?
    By neu_stone in forum Word Formatting & General
    Replies: 0
    Last Post: 09-29-2015, 11:49 AM
  7. [SOLVED] 2016 calendar - A column
    By noddyneil in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-18-2015, 02:07 AM

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