March 17

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”


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


You may also like

February 17, 2022

Edit Excel Formulas in WORD – Spreadsheet Tips and Tricks

February 8, 2021

51: Oz du Soleil & the Global Excel Summit 2021

January 29, 2021

Global Excel Summit 2021

January 22, 2021

50: Randy Austin – Excel for Freelancers

January 8, 2021

49: Theresa Estrada – Microsoft Principal Program Manager Lead

May 26, 2020

All Excel LOOKUPs Explained
  • 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"}

    Free Power User Quick Guide

    Discover The BEST Ways To Use Lookups And Conditional Calculations Quickly And Easily With This Reference Guide -- You Won’t Want This To Leave Your Side

    With so many ways to use Excel, it can be difficult to memorize all of the key functions, calculations, and techniques you can employ to meet your goal: simply get the job done.