+ Reply to Thread
Results 1 to 4 of 4

How to calculate if a date is true if its older than 1 year from TODAY

  1. #1
    Registered User
    Join Date
    04-22-2020
    Location
    England
    MS-Off Ver
    365
    Posts
    39

    Question How to calculate if a date is true if its older than 1 year from TODAY

    Hi Guys, cant rack my brain around this I have a column of dates, many are blanks and i am trying to get a formula that calculates if the date in the cell is newer than 1 year ago today so it has to be a rolling number that changes with todays date minus 365

    for instance todays date is 22-4-20 and i have some that happened on 23-6-19 then it would return the value true or 1 would be better but if that date was older, say 10-01-19 as in older than 1 year ago from today then it would return 0

    Any help would be mostly appreciated

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: How to calculate if a date is true if its older than 1 year from TODAY

    Try
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    04-22-2020
    Location
    England
    MS-Off Ver
    365
    Posts
    39

    Re: How to calculate if a date is true if its older than 1 year from TODAY

    Amazing, thank you for helping, that works perfectly, you've just saved me a lot of head scratching

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: How to calculate if a date is true if its older than 1 year from TODAY

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ 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. Replies: 3
    Last Post: 10-06-2015, 05:30 PM
  2. [SOLVED] Formula to compare date (including month and year) from a listed date to today's date
    By mhewitson15 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-11-2014, 05:31 PM
  3. If date older than today color cell RED
    By chococharlie in forum Excel General
    Replies: 5
    Last Post: 06-02-2014, 05:54 PM
  4. Replies: 5
    Last Post: 01-29-2014, 09:49 PM
  5. Need to calculate if date older than a period determined
    By lilKungka in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-07-2013, 09:40 PM
  6. Replies: 3
    Last Post: 08-14-2012, 05:14 AM
  7. How do I add a range by date over 90 days older than today
    By John DeLosa in forum Excel General
    Replies: 4
    Last Post: 02-16-2006, 05: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