=DATE(YEAR(TODAY()),MONTH(TODAY()),1) In Excel, 1 is one day (and never one hour) So we just have to subtract 1 to the formula to return the last day of the previous month =DATE(YEAR(TODAY()),MONTH(TODAY()),1)1 If you want to show that you are an Excel pro to your friends, you can replace the 11 in the formula by 0 The result is the sameDownload the featured file here https//wwwbluepecantrainingcom/wpcontent/uploads/ReturnMonthorDayNamefromTextxlsxIn this video I demonstrExtract/get the year, month and day from date list in Excel Take below date list as an example, if you want to get the year, month and day numbers from this list, please do as follows step by step Extract the year number 1 Select a blank cell for locating the year number, such as cell B2 2
How To Convert Date To Weekday Month Year Name Or Number In Excel
How to extract month name and year from date in excel