date formatting

  1. D

    Hidden cell formatting

    I can't find a similar question, so I thought I'd post. I am working on creating a master data sheet from data found on multiple other sheets. I am using the VLOOKUP function to fill in values specified by the Sample ID number. Most everything came over properly, except for the "Birth Date"...
  2. J

    text field keeps re-formatting to date in CSV

    Greetings everyone I have a small but frustrating problem I am trying to prepare a file for exporting into CSV format in order to transfer into a different application For all date fields the format must be US and in following format mm/dd/yyyy. The problem is any date with a day number less...
  3. B

    excel formula to tell if a date (formatted as date) is within range of other dates

    hi all, I'm trying to determine if a date in column A is within the range of dates specified in column B (date start) and column C (date end). Each column, A, B, and C, is formatted as Date. Is there a way to do this? Example: PO Date CT Start Date CT End Date In CT Range...
  4. S

    Date formatting

    Hi I have cells A7 to A37 and cells B7 to B37 which I would like to only have dates put in those cells in the format dd/mm/yyyy, everything else I would like to be restricted. I have formatted those cells but this has not restricted any date formatting etc. Can this be done via custom data...
  5. K

    Formatting Date to MM-DD-YY while using CONCATENATE

    Hello everyone, I am having difficulties with a date properly formatting while I am using the CONCATENATE formula. I have a date in cell B1, which is formatted correctly, and there are also multiple unrelated cells from B2 - B10 that are "input" cells. I am using A15 to with a concatenate...
  6. N

    Date-Based Axis for Pivot Chart Excel 2013

    I would like my date axis in a 2013 Pivot Chart to graph proportionally based on the dates in my data set. I know how to do this without a pivot chart (using scatter plots), but I am unable to do this with my pivot chart. Let's say I have sales data for: Col A : Col B 1/1/2000 : $100...
  7. O

    Cell to return month

    Help...!!!!! I'm needing a formula which will paste text into a cell if another cell is between two set dates. For or example if A1 is between 2/4/15 and 12/5/15 A2 to show April if A1 is between 13/5/15 and 10/6/15 I'd need A2 to show May... And so on. I'd love to be to just format the...
  8. A

    Group data by week with date format axis

    I have data which I want to display on an Excel column chart. It represents the number of sales per week, where the date is the first day of the week: If I leave the dates as dates then Excel interprets this as data for one day out of seven, so I get thin columns with large gaps...
  9. A

    DATE format

    Hi All Hoping one of the brilliant people on this forum can help me solve this dilemma . Sheet: MapblasterData <tbody> <tbody> PTWREF </tbody> <tbody> REPORTEDDATE </tbody> CHG0077755 01-09-14 08:45 CHG0077755 30-08-14 12:29 CHG0085423 31-08-14 09:00 CHG0083824 31-08-14...
  10. J

    How to automate formatting of a raw data dump into a spreadsheet

    I posted a question trying to get some formulas for dates working. Problem solved, however, I'm trying to build a template that everyone on my staff can use. It doesn't work for me to expect the users of the template to do any post-export formatting on the template I am creating. So, how do I...
  11. RJSIGKITS

    Help with TextBox date Formatting

    Hi Forum. I am really struggling with the date formatting of a textbox on a userform playing silly sods when transferring the data to a cell... I need a dd/mm/yyyy format, however If I run the user form and add a date of 01/05/2014 to the textbox it applies to the cell as 05/01/2014, however...
  12. F

    format date

    Hi, I have in column A dates: 31/12/2014 31-11/2013 03/Mar/2014 05:11 AM 04-Jan-2013 07:45 How can I simply in column B select date, to have it one format: DD-MM-YYYY ? When I'm using function "DATE" = date(A1;A1;A1) it didn't work.
  13. H

    VBA to Enter String (Constant) and Last Day of Previous Month

    Hello all, Trying to figure out how I can wing this last thing for a tool I'm building. Basically in cell A1 I need to enter this string "'Gadgets Sales ending' September 30 2013" (September 30 2013 being the variable). Any thoughts on how I can accomplish this would be greatly appreciated...
  14. R

    mmddyyyy to mm/dd/yyyy format

    I have a column that contains dates from our system that displays in "mmddyyyy" format (i.e., 10121999 or 8121998). How do I convert this to a 10/12/1999, 8/12/1998 formatted column?
  15. K

    Dates by day of week of the month

    So I'm trying to figure out the code to simply display the number of the day for the Second Tuesday of the month, but have been unsuccessful thus far in my forum search. I know this is possible in outlook, but creating a self generating email in outlook is a PAIN so I'm using excel to generate...
  16. J

    Date formatting wonky

    I have used excel for years. I understand how to format dates. However, lately, after I tell the cell to format it as a date, and then type in a date, it inserts some random date (not the numbers at all that I entered). Anyone else deal with this? J
  17. B

    Conditional Formatting by Date Help Needed

    Greetings, I am using Excel 2007. I need to conditionally format a worksheet. Specifically a column of dates. The sheet is to show the Student's Names and Dates of Birth. I need to make all the dates between January 1 and September 30 (regardless of year) to be light green cells and students...
  18. B

    Pivotfilter on date- problem formatting field or named range used as criteria

    I am guessing this may be a date formatting 101 question... I have a pivot table based upon data that was brought into the spreadsheet from another system. There is a date field (Date Opened)- values come in with a timestamp. on pivot table, I manually group that date field and can filter...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top