+ Reply to Thread
Results 1 to 2 of 2

If Statement using Today()

  1. #1
    Registered User
    Join Date
    08-04-2020
    Location
    UK
    MS-Off Ver
    2007
    Posts
    1

    If Statement using Today()

    Hi,

    I am having some issues getting a formula to work.

    I have column L as a required handover date for a product, I want the next column to return "chase" if that date in L is within 3 days of the current date + 7 days.

    Current formula as follows:

    =IF(L14-TODAY()+7<=3,"Chase","")

    The cell returns as blank if there is any date in column L and says "chase" when L is blank.

    Any ideas?

    Thanks

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,743

    Re: If Statement using Today()

    =IF((L14-(TODAY()+7))<=3,"Chase","")
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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: 2
    Last Post: 04-28-2020, 09:22 AM
  2. CountIF Statement with multiple criteria using the Today() Function
    By tkelbel in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-07-2019, 09:39 AM
  3. Getting VBA IF statement to behave correctly with =TODAY()
    By Dylan87 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-01-2015, 12:43 PM
  4. [SOLVED] If statement based on date in cell using today function?
    By nobodyukno in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-27-2015, 10:42 AM
  5. If statement - Need to stop the today's date calculation
    By crw reef in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-04-2014, 02:57 PM
  6. [SOLVED] If Statement for today being more than (x) days from cell value.
    By Sc0tt1e in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-18-2013, 07:49 AM
  7. Today Statement ignoring blank
    By safisam in forum Excel General
    Replies: 2
    Last Post: 04-23-2009, 10:01 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