Results 1 to 3 of 3

Excel 2007 : Datedif

Threaded View

  1. #1
    Registered User
    Join Date
    06-09-2005
    Location
    Queensland, Australia
    Posts
    47

    Datedif

    =DATEDIF(I3,DATE(YEAR(TODAY()+184)-1,7,1),"Y")


    The above formula returns a person’s age (last birthday):
    • As at 1 July, last.
    • Each year.
    • Cyclically.


    How do I modify the formula, to:
    • Ignore the “1 July” argument before age 60, but still show the person’s age.
    • Invoke the “1 July” argument, at and above age 60.

    The data input cell, is I3
    Cheers,
    Mick2
    Last edited by mick2; 06-14-2010 at 07:56 PM.

Thread Information

Users Browsing this Thread

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

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