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...
I have been breaking my head around the way of extracting a date range in my excel sheet. Here are the requirements:-
1) My sheet contains 2 Columns ("Date" & "Product ID") and below is a sample set of records and their formats (sometimes I have multiple records with same...
I have below data which generates in skewed date format some come with 4 digit year and some with 02 Digit year .
I am also unable to convert the Date Text into date . Tried all your earlier tips .
I am using Excel 2003
would you be able to help in converting all in an uniform format ...