dd/mm/yy

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

im a newby to excel ..trying to work something out. If date in G1 = H1,then return yes in K1 and N/A in columns L1 to Q1 if false, leave k1 empty and allow input yes or no or n/a date is dd/mm/yy thanks in advance

I would like to restrict the data in a specific column to a date in the following format; dd/mm/yy hh:mm So if anything other than that format is entered in the cell it should display an error message.

Type: dd/mm/yy "("ddd")";@ Shows: 01/04/18 (Sun) However, I want "Sun" to only show "Su". The following idea doesn't work: Type: dd/mm/yy "("dd")";@ Shows: 01/04/18 (01) Any ideas?

I am dragging some data from various sheets and presenting it on a single line =IFERROR(VLOOKUP(H5&"|"&B5&"|"&D5,comments!$A:$B,2,FALSE)&" ("&TEXT(((VLOOKUP(H5&"|"&B5&"|"&D5,comments!$A:$D,4,FALSE))),"dd/mm/yyyy")&")",Z5)&IF(AE5<>""," //-// Picking info: "&TEXT(AE5,"dd/mm/yy")&" "&AF5,"") If...

Hi everyone, how are youyou doing? My problem is that I Have a colums "C" With data of the type 1.12.17 I want to change these data to the date format 01/12/17 (dd/mm/yy) I use a VBA code to replace all the dots with "/" The code looks like this: Sub ReplaceDots() Dim i, k As String i = "." k...

Hi I understand excel will accept a date based on the computer settings. If I have my computer short date set as dd/mm/yy then excel will accept the same format unless i custom formatting it. So If my computer is dd/mm/yy then excel will accept 20/10/2017 but not 10/20/2017 (month can not be 20)...

Hi Guys, My idea is to read the values from the Excel file and list them in ListBox. The idea is a user reads all currently Open tickets that are stored in a workbook and has them displayed in the list box. Then selects an item he'd like to close and just clicks 'Close' button - the status in...