date formats

Hi everyone here! I am not asking your help for any technical help on any specific data set, right now. Just asking a question I am living with. I respect Power Query for it's obvious automation capabilities. But as an Excel user, sometimes I used to think why this tool lacks some capabilities...

Hey guys, i have a formula: dateInQuestion = "3/15/2019" finalDateMonthString = Month(dateInQuestion) = 3 But when i try to format it: finalDateMonthString = Format(Month(dateInQuestion), "MMMM") = "January" What is happening?

I have converted some Apple Numbers spreadsheets to Excel for Mac spreadsheets. I want link a date from sheet 1 into Sheet 2. and get the following example results. Sheet 1 shows date in number format: 42702 and displays Date format 28 November 2016 Sheet 2 shows as 29...

Hello everyone, [This is my very first thread, so please forgive me if I did anything wrong; thank you.] My worksheet has a sequence of 'Tasks' listed in column 'A', the corresponding 'Start Date & Time' in column 'B' and the corresponding 'End Date & Time' in column 'C'. The purpose of...

I have a spreadsheet where beginning in B2, I have todays date formula. B3 then has =B2+1 which I copy down. So the cells in column B will change each day. Then in A2, I reference cell B2 and format it as DD so the cell will show, for example: 05 if cell B2 is April 5, 2014. I then have another...

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.

I receive my bank statements with the date written as: yyyymmdd This notation is without dots or slashes. I can use the replace command to put a dot or a slash behind the year, but do not know how to put on between the month and the day. Have tried to use macro, but when I do the cursor springs...