Use it as a quick way find the first or last day of a month.įor example, use these formulas, where you have a date stored in cell B2: One of my favourite date functions is the end of month function, EOMONTH. To be fair, it’s not ALL problems when you work with dates in Excel. I hope you’re better at remembering this year thing than I am! Excel Date Functions Otherwise, I’ll end up with a lot of surprise entries for December 2022! Now I have to type 12/12/21, instead of just 12/12.
Why doesn’t Excel know what I’m thinking?!?Īnyway, now it’s January, and I’m finishing up some December entries. When I typed 1/1 and pressed Enter, Excel added 2021 as the year, instead of 2022. Excel automatically adds the current year to the date.īut by mid-December, I’m entering lots of dates for things that will happen in January. For most of the year, you just have to type the month and day, then press Enter. Maybe I’m the only one who has this problem, but it’s a pain to add the year to Excel dates, in December and January. Here’s a quick look at dealing with those issues. There are other Excel date problems too, like dates where you can’t change the formatting, and dates for the GetPivotData function. Dates can be tricky in Excel, especially in December and January! In those months, you often have to type the year too, because Excel defaults to the current year.
0 kommentar(er)
