mmmm

I am based in the US but am using a file that originates in the UK (I believe). As you will see from the table below they all appear to be dates but when a formula is used the data doesn't act like a date. I have tried to used format cell function and change to a US format date, with no luck...

help pls. i cant move on my project. kept on encountering this error, " Unable to get the EDate property of the WorksheetFunction class" Here's the code. Thank you!

I am researching my Great Great Grandfathers time during the Civil War. What started to be a simple Excel file has grown to a large file, 25000+ rows. Not what I planned for but the further I got in the research the more I expanded to included all members of his units. I am new to VBA and...

Is there an easier way to fill column B with the month of the date in column A. This is what i am currently doing: Sheet1.Range("B3:B" & Lastrow).Formula = "=Text(A3,""MMMM"")"

Hi everybody. I am new, this is my first post. We in Spanish use a form of dates like: Viernes, 5 de Enero de 2018 (is like: Friday, 5 of January of 2018). In Excel I can use in order to obtain this format the following code: dddd, d "de" mmmm "de" aaaa But I don't know how to use this...

I'm using this to extract a Word OLE document, write to it, then save it as a pdf document; 'Extract File If ActiveWorkbook Is Nothing Then Exit Sub Application.ScreenUpdating = False DestFolder = ThisWorkbook.Path & "\Toolbox Files\121 Files" Set wsActive = ActiveSheet lCnt = 0...

I have the following code in my workbook to populate the date in certain cells when the cells are selected. The formula works to populate both ranges. The issue I am running into is formatting the date differently for the two ranges. I need the first range (cell "E4") to format as "mmmm yyyy"...

When i use MONTH () only, the correct value is returned, namely 7 (July). However, when i use it as follows, - TEXT( MONTH(),"mmmm") to get the month name (July), it gives January! Any advice?