date and text format

Hello, - I have a spreadsheet with loads of rows - In column C, I have dates with mixed formats (DD/MM/YY and MM/DD/YY) - Also some of these dates are showing as text(i.e to the left of the cell P.S The dates are mixed format, I dont need to change them all, which is what will happen. I'll...

When I export my sap reports into excel (use TAB deliminator) to change the date format from 12.03.2019 to 12/03/2019 I use the function =VALUE(SUBSTITUTE(W191,".","/")) and then format it to required format. I want to be able to use VBA to save time The number of columns varies for different...

Hi! Struggling to find a formula (or cell formatting?) to present proper date next to a string. This works fine to present a correct date 5 days from now: =TODAY()+5 however I would need to run something like this: ="5 days from today is "&TODAY()+5 - I'd prefer to keep them together for...

If I have "LAX Marketing Jan 17 True Up", what is the formula that I can use to return the result as "Jan-17"? I currently have :"IFERROR(EOMONTH(DATEVALUE(SUBSTITUTE(MID(A1,MAX(IFERROR(FIND({"Jan ","Feb ","Mar ","Apr ","May ","Jun ","Jul ","Aug ","Sep ","Oct ","Nov ","Dec "},A1),0)),6),"...

Hi, I need help with the following. I would would like to search a cell for date range and then retreive information from another cell. eg: If the Date of a cell is within the month of March, then the cell will retrieve information from another cell and display it. A1 03/1/2018 B1...

Hello all! I'm a basic VBA macro-er and after going through plenty search-results trying to find a solution to my problem I finally opted for posting on a forum. So please don't get too impatient with me when you see how basic my question might be. Its regarding dates and keeping the...

Hello everyone, Big fan of the Mr. Excel forum, and first time posting. Thanks in advance for any advice! A small nonprofit that I am helping gave me a dataset that tracks their donations and I am trying to clean it up for them so we can run analytics. However, the dates for each row (1 row...

Hi everyone, I have a tough issue I need to solve quickly and I really need your help here. I have a DATE column where in some of the records the date appears in Excel formated as GENERAL (aligned to the left in the cell) and I I tried everything to changed it to date but to no avail. The...

Hi, quick question - In cell A1 I have text. Cell A2 has a date, in date format. I would like a formula that will concatenate the text and date and have it read properly (meaning with the date format. E.g.: A1: Trade Date A2: 5/13/17 at the moment when I use either: =A1&" "&A2 it produces...

I have excel A.csv and I tried to copy paste data in excel A to excel B.xlsm But, when I copy data to excel B, in date column change format to text. In excel A , the date format is dd-mmm-yyyy (15-12-2016). In excel B the date format is dd/mm/yyyy (15/12/2016). Below is my code: 'Force...

Hi All, 2 quickies (I hope): 1. Want to turn 201607 into a Month format "Jul" - whats best formula? 2. Once I have identified a start month ex. Jan (in that format) in cell A1 and end month Sep (in that format) in cell A2 I want to create a list with all the months that fall between cell A1...

Hi, I have a long formula that determines dates based on certain criteria. Within the Formula I have a Date formula as follows: DATE(MID(P14,4,4),MID(P14,2,2),MID(P14,1,1)) But the value the formula reads appears as a text e.g. 42586. Can someone tell me how to read the text as a date so I can...

Hi All, Please can someone help me on the below. Can a formula be used to pick up the different months in a quarter? Say I have Q1 in cell A1 and I want cell A2 to pick up the first month of the quarter, A3, the second month of the quarter and cell A4 to pick up the third month of the...

Joining two pieces of VBA Code. Formatting a column to Date Format Hi all. I hope you are well. I have two pieces of code that work and function correctly. The first piece of code essentially executes a Vlookup of three columns using a unique identifier from one sheet and puts them into...

I have some code that defines date values based on a holiday calendar I've created. This code has been working great in another subroutine, but it's suddenly been failing when getting to the "FileDate" variable. In debug mode, I can see that "ThisDate" has a setting, but the reformatting of...

Hi, We are 94 in count and using same no. of machines. 50 of us get default date format as DD-MM-YYYY but rest 44 get the format mm/DD/YYYY in excel workbook. Now, my concern is to apply the same default format as MM/DD/YYYY in all the systems as we work for a USA client. Issue: If a user with...

Hi All, Apologies if this question is about I did search but could not find anything that could help me. First off I am new to the forums and after taking a brief look, it seems to be a great place to get excel knowledge/tips. Explanation/Question: I have a fairly large data extract I do...

Hello all, I am having an issue formatting a cell that contains data from a .txt file into a new date format. The cell shows data as 151201 and the format is "general." When I change the cell format to any date format, I get the date as 12/21/2313. I need it to say 12/01/2015. Can any one...

I am having trouble searching a range containing workday dates for the closest one to the target. Ie. Jan 26, 2014 is on a Sunday, if this is the start date of a project I want the function to output Jan 24,2014. (This function is triggered by another sub, so I'm not really using it to output...

I need to do some quality checks for manual entries by staff into a system which generates an export. I receive the export with entered dates in text form. I need to simply determine if the dates were entered correctly (i.e. proper format). I need formulas for future projects. Column A in table...