Results 1 to 2 of 2

Thread: How to get the date to mean something else?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Sep 2019
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default How to get the date to mean something else?

    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, 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"

  2. #2
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    50,793
    Post Thanks / Like
    Mentioned
    57 Post(s)
    Tagged
    11 Thread(s)

    Default Re: How to get the date to mean something else?

    Welcome to the Board!

    I do not know about anybody else, but I am thoroughly confused by your question. I think it would be very helpful if we could see some detail, such as a sample of the data you are working with, and what your current formula is.

    There are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.
    There is also a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.

    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"
    One last question: Are you trying to do this in Google Sheets or Excel?



    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •