All Questions
4
questions
0
votes
2
answers
98
views
How to manipulate dates?
How can I change a date in an Excel file
to eliminate the day and be left with only the month and year?
E.g., convert 4/4/2019 to April-2019?
I am aware that I can change the format, but if I do so, ...
0
votes
2
answers
376
views
How to convert malformed dates in mixed formats?
I am working on a project to clean up my company's data. One particularly horrid file is an Excel sheet with approximately 30,000 rows.
The date columns in this sheet are populated with dates in many ...
1
vote
1
answer
83
views
excel and birthday format
I am new to this. I do not have a screen shot for this one.
In the region I am located the birthdays are listed as: yy-mm-dd
I have: 720415 and want to convert it to: 72-04-15.
Will following work:
=...
0
votes
1
answer
484
views
How do I use the formatted value of a cell
I have a cell A1 containing a date formatted as date so that it shows 28.Oct.
I want to use that formatted date embedded into a piece of text like this: "Today is the 28.Oct and it is sunny".
I have ...