+ Reply to Thread
Results 1 to 3 of 3

Trying to use the TODAY() function as a condition in an IFS() function

  1. #1
    Registered User
    Join Date
    11-19-2019
    Location
    salem, oregon
    MS-Off Ver
    2019
    Posts
    2

    Trying to use the TODAY() function as a condition in an IFS() function

    I am trying to use the TODAY() function as a condition in an IFS() function. This is my equation: =IFS(TODAY()<20, P10, TODAY()>=20, P9) . Am I using properly, or is there a better solution?

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Trying to use the TODAY() function as a condition in an IFS() function

    Use: =IF(DAY(TODAY()) < 20, P10, P9) or =IF(TODAY()) < DATE(YEAR(TODAY()),MONTH(TODAY()),20), P10, P9)
    Click the * to say thanks.

  3. #3
    Registered User
    Join Date
    11-19-2019
    Location
    salem, oregon
    MS-Off Ver
    2019
    Posts
    2

    Re: Trying to use the TODAY() function as a condition in an IFS() function

    Thank you, I was letting my mind be to complicated.

+ 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: 10
    Last Post: 09-06-2023, 08:19 PM
  2. [SOLVED] Using TODAY function inside the SUMIFS function
    By taraberg_321 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 04-26-2019, 10:32 AM
  3. [SOLVED] Nested if with today function and datedif function
    By KIMMEYER in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-06-2016, 10:12 AM
  4. Replies: 4
    Last Post: 08-24-2016, 09:29 AM
  5. [SOLVED] Can I add an 'or' condition to the COUNTIF function? If not, what other function can I use
    By newbie0101 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-09-2012, 01:41 AM
  6. Using the TODAY() function in a SUMIF function
    By JPB in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-27-2006, 11:01 AM
  7. How do I use the TODAY function with the SUMIF function?
    By Lisa B. in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-30-2005, 04:05 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