LinkBack URL
About LinkBacks
I'm trying to work with a sheet which has a column of date which has this format "Mar-30 2018 20:44". I tried using aging formula "=TODAY()-DATECELL" but it giving value error.
Looks like column data is not recognized as date type. Please help.
Excel doesn't recognize dates
I'm trying to work with a sheet which has a column of date which has this format "Mar-30 2018 20:44". I tried using aging formula "=TODAY()-DATECELL" but it giving value error.
Looks like column data is not recognized as date type. Please help.
DATECELL is not a valid function. What is your formula? Do you have a UDF in your workbook? Are you sure your dates really are dates or just text?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Select the entire column, go to Data - Text to Column - Next - Next - Select Date format and Destination as the first cell in the same column - Finish.
Click the * to say thanks.
It seems to me that this "Mar-30 2018 20:44" is a text string. So, it needs to be converted to a real date.
Try this:
Assuming "Mar-30 2018 20:44" is in cell A1
Enter formula in B1
Formula:
Please Login or Register to view this content.
Or this shorter version
v A B 1 Mar-30 2018 20:44 107
Formula:Please Login or Register to view this content.
Last edited by AlKey; 07-16-2018 at 09:11 AM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thanks for the response. "=TODAY()-DATECELL" is the syntax i follow. By DATACELL i mean the cell address of the DATE(Actual formula usage is =TODAY()-D2)
Thanks.Tried this but not working.Date type is not identified even after this.Originally Posted by PaulM100
Thank you..The data type shows general and i tried changing it to use the formula.Its giving value error after i use the formula.
Last edited by AliGW; 07-16-2018 at 11:31 AM.
Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!
For normal conversational replies, try using the QUICK REPLY box below.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks