Google Sheets - Show a Date as a Month Name

It can be tricky to display the month in which a particular date falls. This tutorial will walk you through two different ways to do it.

#googlesheets #dates #month

[jordanschwann]

Amazing video. this worked. Thank you!

[lauriedale]

Hey there, I have a bunch of data with several rows of the same date with different times, for every day, however I only need 1 date\time a day. Is there anyway to filter to one row per day? Thanks so much!

[nuraiyan]

I v got short name of month. How i can set up full name and index ?

[rumadztwal]

Amazing video. If you are going what I'm going through, =TEXT(TODAY(), "YYYY") for year and =TEXT(TODAY(), "MMMM") for month

[Grandliseur]

I liked your video. I've had good experience with date formatting problems. Because of age, I'm just having personal fun with it. I wonder though, how do international companies deal with the varied types incompatible date formatting in e.g. Canada, US, UK, etc. (yyyy-mm-dd or dd-mm-yyyy, etc)
I realize this may be impossible to answer briefly.
E.g. I just shared a Google Sheet internationally, Canadian country format, my date calculations naturally stopped working on a different country format.

[jshggep]

I am looking for a way to take a date and, in a separate column, have the date reflect how many months the date is to the present date. For example, If I was born on 5/15/2021 how many months am I given any future date. Is there a way to do that?

[CaribouDataScience]

How do I sort by month i.e. Jan for the correct month order?

[thomasfreimoser]

Sadly, doesn't work with timestamps :(