Entering two dates in a single cell and retaining the date format
I want to fill in two dates inside a cell and still retain the date / time / number format of the particular data. For example instead of writing "02 Feb 21 to 12 Feb 21", can i get the result as "02-Feb-21 (to) 12-Feb-21". So that in future i can sort the date bases on first or last dates.
Welcome to the forum.
In a word, no. You will need helper columns with single dates if you wish to sort on dates.
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
It is almost always better to keep 1 specific piece of data in a cell, rather than combining different data types.
A date is numeric, but ANY time you add text to a cell, no matter what else is in that cell - even numbers - that cell format becomes text.
So if you have dates, put 1 date in 1 cell,, and the other date in another cell.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks