March 17

What Function Sounds Like a Number But Returns a Date? Excel Challenges

1  comments

What Function Sounds Like a Number But Returns a Date? Excel Challenges

We do things a little differently here at Excel.TV.

On most websites, you might expect that Excel Challenges and Problems were scored based on their accuracy.  Particularly when a high-end designer Excel.TV beer coozie is at stake.

If Answers to Excel Challenges were based on accurate answers, we would have plenty of winners.

Here is one such example from Bill Jelen “Mr Excel”

2015-03-17_15-54-07

Sounds Legit?  Right?

Well, it probably is.  But it wasn’t the answer that Jordan was looking for… so too bad.  You must try again for your chance at a beer coozie and Excel Tables Book by Kevin Jones and Zack Barresse , Bill.  But please realize that in addition to the correct answer, Jordan may just as likely be thinking of the number “42”.  So take your chances.

2015-02-03_20-55-27What Function Sounds Like a Number but Returns a Date?

The challenge was offered March 10, 2015. Leave your guess in the comments section below.

While We’re Here…

We learned some important things in this episode.

Like… having the right answer to the challenge is not good enough.  Regardless of the correct answer, you must guess the answer that Jordan is thinking about. Like the Amazing Carnac, you must know ahead of time what Sis, Boom, Bah refers to.

Previous Episode’s Winner

Congrats to Rob Waardenburg for winning the previous challenge. The year that sparklines were added to Excel was 2010 — or version 2010.  Catch the previous Excel Challenge here

Leave Your Answer Below

First off…  sign up for our Newsletter. Or better yet, just sign up for our Excel Book Club and get a free Chapter from Jordan’s book, Advanced Excel Essentials.  Sign Up Here

Loved this? Spread the word


About the Author

I am the Director of Business Intelligence at a Consulting Firm and am responsible for leading reporting and analytics deployments. I am also a Founder at Excel TV and am dedicated to making this community a home base for Excel users. A place where experts share strategies to Cleanse, Automate and Visualize data.

Rick Grantham

Related posts

Who Is Considered The Father Of Pivot Tables? – Excel Challenges

Read More

Fonts That Make Bars Look Filled & Complete – Excel Challenges

Read More

How To Calculate RGB Colors In Excel? – Excel Challenges

Read More

Colors Available in ColorIndex Property – Excel Challenge

Read More
  • What Function Sounds Like a Number but Returns a Date?
    Given that any “date” in Excel is actually a number disguised (formatted) to look like a date, the answer to Jordan’s question is technically limited to “There isn’t one”!
    However, I suspect that’s not the answer he is thinking of, so I’ll try another tack. I can’t think of or find any function that “…sounds like a number…”, but can imagine some people think that the DATEVALUE function would return a number when it actually returns a date.

  • {"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

    Subscribe to our newsletter now!

    >