mm/dd/yyyy

Greetings Excel community, I have a set of ID's and dates which are associated to these ID's. The ID's are repeated but there are numerous dates associated with its respective ID. What I am attempting to accomplish is combining all the dates associated with the specific ID. For example, ID 123...

Hi dear forum, I just thought I would post this little demo here which, just like the thread title reads, it shows an attempt to mimic the watermarks that we sometimes see in some web forms. I was spurred to it by the question asked in this recent thread ... The result I have obtained looks...

Greetings Excel Community, I have numbers formatted in the following Text or general format: 20221026.. I am trying to format it as mm/dd/yyyy.... I have used a formula as follows but it is not generating the correct output: Formula is =DATE(LEFT(G2|4)|MID(G2|5|3)|RIGHT(G2|2)). I am including...

Hi all, I have a few columns of dates that are formatted in MM/DD/YYYY. There are hundreds of dates in these columns and I am looking for a way to roll these up into each of the dates respective quarters. Essentially looking for a formula that will either countif or sumif the number of dates...

I have a date stored in a variable: invDate (mm/dd/yyyy). As part of my sub I need to convert it to text in the format "yyyy-mm-dd". I've seen several solutions on this board, but for some reason they aren't working for me: expItemDate = VBA.Format(CStr(invDate), "yyyy-mm-dd") - doesn't work...

Hi everyone, I've been stumped by this for a while now: when I try to convert a date value form mm/dd/yyyy to mm-dd-yyyy, and output it as a message box, the code works perfectly. However, when I try to put this value into a cell, it reverts back to the original formatting of mm/dd/yyyy. I know...

I have a workbook with several pivot tables created from the same pivot cache. The dates in the original data table are formatted as mm/dd/yyyy (11/30/2018). All of the pivot tables, however, show the date as dd-mmm (30-Nov). I have gone into Field Settings and changed the number format to...

Dear All, The attached excel sheet have date value in different cells , But excel won't recognise as date , So i want all cells date value recognise as a date value in (mm/dd/yyyy) format. While applying formula on cell values it won't recognise as a date value. Oct 1,2018, 2:05 PM Oct 1...

Is it possible to hardcode a date using a formula based on another cell criteria? Like if A1 does not equal blank B2 equals today’s date mm/dd/yyyy or can this only be achieved through VBA?

I have seen references here to formulas like this =MIN(IF(A1:A3="",0,A1:A3)) What I'm doing is this =MIN(G2,I2) I want the minimum value (earliest date/time) from one cell or the other which are in date/time (mm/dd/yyyy hh:mm) format. The only issue is, it represents 2 blank cells as...

Hey. I've run into a problem: I've been supplied with dates, of which I need to remove anything that is 4 weeks or more from today's date. Now the problem is that the dates I've been supplied with are in the format (dd.mm.yyyy), while excel gives today as (mm/dd/yyyy). How can I get around the...

Hello Ladies and Gentlemen, I have a column of dates, that I want in UK date format (DD/MM/YYYY) Occasionally, the data I receive the dates are muddled up, some are in DD/M/YYYY and some are in MM/DD/YYYY The ones with a star are incorrect, and come in 'General' format...

I have two macros I want to stitch together. Both on the bottom. How do you stitch them together? Is there an easy How-do somewhere? Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next Range("A1").Sort Key1:=Range("A2"), _ Order1:=xlDescending, Header:=xlYes...

I need help in converting dates from this format: YYMMDD 180422 My desired result would be (with slashes): MM/DD/YYYY 04/22/2018 Any takers? Thanks! Eric

Hi all I'm pulling my hair out with this. I cannot get the auto filter to work, I'm sure im missing something but cant seem to see what???? The code below is run from a userform, i've split it into two subs which I'll combine later. I've got all the dates into mm/dd/yyyy format as from past...

Hello I am working in excel 2010 and I have a spreadsheet with many rows of long Text, in Column A. Within each text string at some point is date which is always in the format mm/dd/yyyy. I am trying to find a formula that I could put in each cell of column B that would capture this date in...

Hello, I have data being recorded every 30 seconds, however, I would like to filter it down to once every 6 hours. It's currently displayed in one cell as mm/dd/yyyy hh:mm:ss AM/PM. Any suggestions to how I would go about this? Thanks so much!

Hi: I need to verify whether the dates in my Excel table in the correct format, which is "yyyy/mm/dd", so any other formats like "mm/dd/yyyy" would be incorrect. I am using this formula: =IF(NOT(ISERROR(DATEVALUE(<wbr style="font-family: Calibri; font-size...

We have been keeping a list of item where one column has the date expressed as yyyy. We have some information where we actually have the mm/dd/yyyy, but not always. When I have some rows with just the yyyy and some with mm/dd/yyyy - the "Filter" does not search/find all entries. Example: If...

? Format("06 Jan 1990", "mm/dd/yyyy") 01 06 1990 Why does it not result in 01/06/1990 like its being told to ?? Using Excel 2007. Thanks.