Results 1 to 3 of 3

How to have a date appear instead of a designated value?

Threaded View

  1. #1
    Registered User
    Join Date
    06-10-2019
    Location
    Nyack, NY
    MS-Off Ver
    Windows 10 Home
    Posts
    19

    How to have a date appear instead of a designated value?

    Good morning all,

    I was curious if someone could lead me in the right direction? I was given the task by my manager to put together a spreadsheet that tallies up the amount of time someone spent in a certain classroom.

    They want the amount of time, 2 or 4 to be color coded but they do not want the numbers 2 or 4 to appear in the cell. Instead, they would like the date to appear as 9/12, 9/13 etc, no need for the year.

    The tricky part is that the formula I am using is adding up all the seat time so 2 and 4 work perfectly and the dates would just throw off my formula. Any ideas?

    To be honest too, I used Google Sheets and now my formula for a drop down option isn't listed but appears in Excel once you type in "2 or 4"

    I prefer to use Google Sheets as the principal is trying to share this with the school.

    Please see attached for the Excel spreadsheet.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Designated Amountsa
    By KoryR in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-01-2019, 07:41 PM
  2. [SOLVED] Trying to setup a speadsheet that auto updates values that i've designated by date
    By NathanKinard in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-30-2017, 02:31 PM
  3. [SOLVED] Trying to setup a speadsheet that auto updates values that i've designated by date
    By NathanKinard in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-29-2017, 01:57 PM
  4. shell to search for a designated term in a designated folder
    By drech in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-27-2016, 01:33 PM
  5. [SOLVED] Pull a string of data to start in the designated date
    By JLiao310 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-03-2015, 09:11 PM
  6. [SOLVED] Summing by section designated by date
    By zookeepertx in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 04-30-2015, 05:46 PM
  7. Designated a cell as a name range
    By Fastbike in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-30-2005, 11:31 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