date 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"...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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.

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...

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?

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...

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

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...

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...