+ Reply to Thread
Results 1 to 2 of 2

Creating an age range for a Date feld

  1. #1
    Registered User
    Join Date
    06-03-2016
    Location
    Scotland
    MS-Off Ver
    2010
    Posts
    1

    Creating an age range for a Date feld

    Hi there,

    I am trying to create a column within my workbook that will calculate the age of a date column then output the undernoted categories:

    1 - 2 Month
    2- 3 months
    3 - 4 months
    4 - 5 months
    5 - 6 months
    < 6months

    I can programme this in SAS but can seem to workout the syntax for the formula in Excel 2010. Can anyone help with this, I was using an IF statement with a Today() function but couldn't get the output like the above, it would only give me a number.

    Many thanks

  2. #2
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Creating an age range for a Date feld

    Is this what you're after

    Please Login or Register  to view this content.
    Happy with my advice? Click on the * reputation button below

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need help creating a formula to check a date range
    By bbeards2 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-20-2015, 11:43 AM
  2. Nead help getting text value depending on another text feld
    By Mrturbo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-28-2015, 07:30 PM
  3. [SOLVED] creating a named range taking the avg. to date of a dynamic range.
    By siggisigg in forum Excel General
    Replies: 1
    Last Post: 07-15-2014, 08:58 AM
  4. creating a date range on sheets
    By mbote131 in forum Excel General
    Replies: 4
    Last Post: 07-08-2011, 05:40 AM
  5. Excel 2007 : Creating a cost based on a date range.
    By iaing80 in forum Excel General
    Replies: 1
    Last Post: 04-23-2011, 06:14 PM
  6. Creating Headers within a date range
    By orivera in forum Excel General
    Replies: 1
    Last Post: 07-25-2008, 07:22 PM
  7. creating a date range trigger
    By gazzo in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-06-2007, 07:00 PM

Tags for this Thread

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