+ Reply to Thread
Results 1 to 7 of 7

How to use "If" functions with "today" function

  1. 12-25-2022, 11:01 PM #1
    cpowers
    cpowers is offline
    Registered User
    Join Date
    12-25-2022
    Location
    Kansas City, Missouri
    MS-Off Ver
    Up-To-Date
    Posts
    1

    How to use "If" functions with "today" function

    Hello, I am trying to combine the "Today" function and the "IF" function. However, it isn't going how I had hoped.

    At the top of the spreadsheet, I used the "Today" function. I then used +1, +2, etc. until I completed the week.

    What I want to happen is when the date updates and says "Sunday", "Monday", "Tuesday", "Saturday" it will output a specific name. IE: Bob
    If the date up top doesn't show one of these 4 values then it will fill it with another name. IE: Jill

    How would I write a formula to work off of the "Today" function and have multiple strings for the days of the week an individual works?

    Thank you for your help!
    Reply With QuoteRegister To Reply
  2. 12-25-2022, 11:09 PM #2
    Sam Capricci
    Sam Capricci is offline
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: How to use "If" functions with "today" function

    this would be one way to accomplish that...
    =IF(OR(TEXT(A1,"dddd")="Sunday",TEXT(A1,"dddd")="Monday",TEXT(A1,"dddd")="Tuesday",TEXT(A1,"dddd")="Saturday"),"Bob","Jill")
    assumes =today() is in A1 and in A2 is =today()+1 dragged down.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci
    Reply With QuoteRegister To Reply
  3. 12-25-2022, 11:23 PM #3
    HansDouwe
    HansDouwe is offline
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,419

    Re: How to use "If" functions with "today" function

    Welcome to this forum.

    Fast answers need clear examples. Please post a small Excel sheet with manual added expected results. See yellow banner at the top of this page.
    Reply With QuoteRegister To Reply
  4. 12-25-2022, 11:44 PM #4
    josephteh
    josephteh is offline
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,057

    Re: How to use "If" functions with "today" function

    Alternatively, =CHOOSE(WEEKDAY(A1),"Bob","Bob","Bob","Jill","Jill","Jill","Bob")
    Reply With QuoteRegister To Reply
  5. 12-25-2022, 11:50 PM #5
    HansDouwe
    HansDouwe is offline
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,419

    Re: How to use "If" functions with "today" function

    An other guess:

    Or may be in A3 and copy to right:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    assumes today and the next 6 days are in A2:G2
    Attached Files Attached Files
    Last edited by HansDouwe; 12-25-2022 at 11:53 PM.
    Reply With QuoteRegister To Reply
  6. 12-26-2022, 12:59 AM #6
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: How to use "If" functions with "today" function

    just for fun with Power Query

    this is an example of using Power Query for simple things (with Table.FromRecords())

    FName
    Bob
    		 


    Please Login or Register  to view this content.
    • - this will show the corresponding name for the corresponding day of the week
    • - the name will update automatically every day
    • - the table refreshes immediately after opening the workbook or after pressing Ctrl+Alt+F5 (your choice)
    • - names can be changed as you wish
    • - no need for anything extra in the sheet
    Attached Files Attached Files
    Last edited by sandy666; 12-26-2022 at 01:04 AM. Reason: cosmetic
    Reply With QuoteRegister To Reply
  7. 12-26-2022, 02:47 AM #7
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,587

    Re: How to use "If" functions with "today" function

    In A2 copied across.

    =IF(WEEKDAY(A1,16)<5,"Bob","Jill")
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Multiple layered "IF" functions or better use of "SMALL"/"LARGEST" funtion.
    By DexterStagg in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-12-2020, 09:14 AM
  2. Budget assist: Entering "Weekly" "Fortnightly" "Monthly" OR "Yearly" with formulas
    By Windyz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-05-2019, 12:03 AM
  3. [SOLVED] Help on "IF", "FIND", "SUBSTITUTE", & "LEFT/RIGHT" FUNCTIONS
    By pooja135 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-20-2018, 03:56 PM
  4. [SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"
    By excel-card-pulled in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-07-2017, 09:30 AM
  5. Don't know the Forumlas with problem either using "vlookup" "if" "and" or "index" "match"
    By Jokeman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  6. HELP on "left","right","find","len","substitute" functions
    By serene83 in forum Excel General
    Replies: 5
    Last Post: 06-26-2006, 09:23 PM
  7. [SOLVED] Please add a "sheet" function like "row" and "column" functions
    By Spreadsheet Monkey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-08-2005, 12:15 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1