=IsDate() Returning #VALUE! (Nothing found on Google Search)

[schulzy175]

I cannot get the "IsDate" function to work at all. I've tried with everything except a new workbook. Here is a screenshot. It is really weird.

isdate.PNG

[sandy666]

I think you should check if ISDATE() exist Excel Functions

[Sam Capricci]

when I search for ISDATE it comes up as a VBA function but not standard.
https://www.techonthenet.com/excel/formulas/isdate.php
but, if you question if a date is real or not the ISNUMBER should work as all dates are numbers, just formatted to look like dates.

[schulzy175]

Here is a blank new spreadsheet with a similar table as the screenshot.

IsDate.Function.xlsx
https://drive.google.com/file/d/1kJN...ew?usp=sharing

[sandy666]

Maybe try here:
For Other Platforms(Mac, Google Docs, Mobile OS etc)

[schulzy175]

Maybe try here:
For Other Platforms(Mac, Google Docs, Mobile OS etc)

Try there as in reposting the issue or searching for solutions? I apologize, but I don't follow.

[sandy666]

maybe there you will find a solution.

here: attach example excel file not a link to google

[Sam Capricci]

your link showed #NAME? which means that whatever platform you are using excel doesn't recognize that as a formula. I believe Sandy was directing you to the other platforms forum here on excelforum as maybe that is where your problem lies.
I can tell you that I get #NAME? if I type in =isdate(A2) and have a date in A2. I don't think it is a standard function and is used with visual basic. If you have a date, that is a number that is simply formatted to look like a date whether it looks like January 2018, January 1, 2018 or Jan-1-2018 or other ways. So using =ISNUMBER will show if it is a date since all dates are simply numbers from 01/01/1900 forward (or 01/01/1904 if your system uses that - which can be found in your properties).
so, 6/21/2018 is 43272 days since 01/01/1900.
Where have you used =isdate and had it work?

[schulzy175]

your link showed #NAME? which means that whatever platform you are using excel doesn't recognize that as a formula. I believe Sandy was directing you to the other platforms forum here on excelforum as maybe that is where your problem lies.
I can tell you that I get #NAME? if I type in =isdate(A2) and have a date in A2. I don't think it is a standard function and is used with visual basic. If you have a date, that is a number that is simply formatted to look like a date whether it looks like January 2018, January 1, 2018 or Jan-1-2018 or other ways. So using =ISNUMBER will show if it is a date since all dates are simply numbers from 01/01/1900 forward (or 01/01/1904 if your system uses that - which can be found in your properties).
so, 6/21/2018 is 43272 days since 01/01/1900.
Where have you used =isdate and had it work?

Your reply pretty much sums up what I was beginning to understand. I've made so many spreadsheets since I've had to use "=IsDate()" that I will have to go through my files to find one. I have used "=IsDate()" in the past, but cannot recall if it was through a worksheet formula or VBA. Either way, I can stop searching for a solution now. Thanks.

@sandy666 - I couldn't figure out how to attach the file using the reply box. (Even if i click 'Go Advanced') So I just uploaded it to the drive. I found the option for Attachments, but this is what I get.
attachment problem.png

[sandy666]

To attach an Excel file to your post,

• desensitize data
• remeber that your example should reflect structure and type of data and contain the result what you want to achieve (manually created if necessary)
• click Go Advanced,
• scroll down until you see Manage Attachments,
• click that and select Browse,
• select your file and click Open,
• click Upload and you will see your attachment below Upload Files from a website
• click Close this window,
• click Submit reply

After that you should see attachment in your post

[Sam Capricci]

to attach a file you go to the "go advanced" button below the reply window, then roughly midway down is hypertext Manage Attachments, click that and it opens a window, then, I like to save my files I attach to the desktop so it is fewer clicks but a window with browse is beside it so you go after the file then hit ok then close the window and you hit post or ok again and it will show up.

[schulzy175]

To attach an Excel file to your post,

• desensitize data
• remeber that your example should reflect structure and type of data and contain the result what you want to achieve (manually created if necessary)
• click Go Advanced,
• scroll down until you see Manage Attachments,
• click that and select Browse,
• select your file and click Open,
• click Upload and you will see your attachment below Upload Files from a website
• click Close this window,
• click Submit reply

After that you should see attachment in your post

Sweet, I found it. Thanks.

[sandy666]

I'm glad you found it but don't quote whole post

[FDibbins]

Your version indicates 2016, and there is no native ISDATE() function there.

Besides, a date is just a number representing the number of days passed since 1/1/900...and then formatted in a way that we recognize as a date. So, for instance, today (Thu 21 Jun 2018) is actually 43272, so Im not really sure how excel would determine that any large (5-digit?) number is a date, or just a number - without maybe looking at the number format.

That is more than likely a UDF (User Defined Function that someone created

[Zer0Cool]

VBA Function as seen here

Not a sheet function. Also, as I recall, not very accurate.

[FDibbins]

Zer0Cool, thanks for the input and the link