+ Reply to Thread
Results 1 to 5 of 5

If Statement for today being more than (x) days from cell value.

  1. #1
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Usually at work, in the UK
    MS-Off Ver
    Excel 2010
    Posts
    639

    If Statement for today being more than (x) days from cell value.

    I have been playing with If statements to attempt to work out if a value in a cell is more than 7 days difference from Today().

    I would like to do this as one formula rather than haveing a formula to work out the difference with a value in a different cell and then calling on the cell to see if it is greater/less than (x).

    I've tried all the variations I can think of but can't quite get the syntax of greater than "X" of today.

    If A1 is greater than "x" days of Today() then True, False.

    Does anyone have a solution please?

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: If Statement for today being more than (x) days from cell value.

    try:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Usually at work, in the UK
    MS-Off Ver
    Excel 2010
    Posts
    639

    Re: If Statement for today being more than (x) days from cell value.

    What is the ABS bit?

    Forgot to mention this is on Excel 2003, will it still work?

  4. #4
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: If Statement for today being more than (x) days from cell value.

    Quote Originally Posted by Sc0tt1e View Post
    What is the ABS bit?

    Forgot to mention this is on Excel 2003, will it still work?
    You asked to indicate if a date was greater than 7 days difference from today - the ABS function takes the absolute value of the difference, so considers the scale of the variance, not the sign.

    It will work perfectly with 2003.

  5. #5
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Usually at work, in the UK
    MS-Off Ver
    Excel 2010
    Posts
    639

    Re: If Statement for today being more than (x) days from cell value.

    Hmmm, something new to play with.

    Thank you very much, works a charm

+ 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] Conditional formatting - highlight cell if it's empty 2 working days before today
    By uhtfgy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-16-2013, 06:20 AM
  2. I need the color of the cell to change when within 30 days of today's date
    By splate in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-06-2013, 12:53 AM
  3. Select a cell in a row 30 days prior to today's row
    By jphalverson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2013, 10:34 AM
  4. Replies: 6
    Last Post: 04-26-2012, 09:51 AM
  5. Replies: 4
    Last Post: 03-12-2012, 03:44 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