Create Column of Month End Dates in Excel - Excel Magic Trick 1556

In this video learn how to create a Column of Month End Dates in Excel using the Fill Handle, the Angry Rabbit (Crosshair Cursor), and a Auto Fill Options Smart Tag.

[ismailismaili]

Even a 1 minuet video is super duper thank u so much Mr. Mike

[wayneedmondson]

Hi Mike.. love that Smart Tag with Auto Fill Options. Saves tons of time. Thanks and Thumbs up!

[chrism]

I never even noticed that Mike, thanks!

[GeertDelmulle]

You should call these Excel Quickies... :-)

[SyedMuzammilMahasanShahi]

Thank you so much Mike for this EXCELlent video :P

[katerina]

Another helpful video Mike, thank you

[rrrprogram]

Ohh yaa... I knew this bcoz of excelisfun videos

[excelbear]

haven't been active in Youtube, but I'll continue to support your channel whenever i can! i'm constantly amazed of how you can keep coming up with topics.

[roya]

ahhh...why didnt you tell me this last week when I needed it? jk good vid tks

[JeffBlankenship]

Great video, is there a way to have Excel calculate the last working day of a month?

[barttitulaerexcelbart]

Hey Mike, something new these short video's: I like it, maybe put them in a new group like "SET" (Short Excel Trick) ? In my neighbour country they say: "In der Beschränkung zeigt sich der ha.

[alicemorili]

How to get last business day of the month?

[sarasamin]

thanks for this quick tip but it didn't work for me.any reason why?

[beewhyfocus]

This smart tag doesn't seem activated on my office 365 excel

[rickphillips]

Your videos are awesome! What program do you use to create them?

[Bramble]

Is there any way to get dynamically updated information with filters side-by-side on a single spreadsheet? Use case: I have a box with time slots down the side and locations across the top. When someone reserves a time/location, it appears in this section. So you get an at-a-glance picture of what's available and when. Users really like that. And it updates dynamically whenever a new reservation is made. Next to it, I have the list of reservations in rows. Right now they're listed in a table, and the table directly reflects the actual reservation information I have stored on another sheet. I want to be able to sort and filter on the reservation rows. The ability to filter and sort is also very useful for understanding current reservation availability. The table provides this functionality built in. But when I filter, it filters out the entire row(s), which screws up the visual representation on the other side of the screen.

[stephenbrincat]

Mike, why is my smart tag showing quick analysis, not auto fill option?

[larsbreughel]

Hi there Mike. I have a problem with the formula from Excel Magic tricks 185 video. Can you help me? I emailed you in gmail day or two ago. Please help me.