πŸ—“ Month, Day, and Year Math Functions

Woohoo!

Month(), Day(), Year()

Now we just need hour, minute and second?

16 Likes

You give people a Year, they’ll ask for a Second!

15 Likes

Seriously. This is super helpful!

3 Likes

Is this new, too? The ability to delete a spreadsheet column from GDE?

5 Likes

Oh…and Weeknum()! I use this ALL THE TIME for weekly records, logs and leaderboard!

7 Likes

All this new date format options are super helpful! Thanks!! :heart_eyes:

2 Likes

@yinon_raviv Now you can use this for your 100% Glide Sheets app.

2 Likes

This shouldn’t be a thing. Are you sure this is not a Glide Table?

1 Like

Sorry @Robert_Petitto

Is that pretty Month column getting the value from Date column?

That’s what I really need …, not independent date values with different formats in different columns…

:thinking:

Yep! Getting it from the date column!

Ah. It was a Glide table. :see_no_evil:

1 Like

This is great

Not posible using google sheets? How do you do that? How do you call the value? Could I see the insights of the month. column for example?

Thanks. @Robert_Petitto

Just call month(X) and replace X by the datetime column.

But in excel? This wouldn’t be new…

No you do this in a math column.

1 Like

+1 for WEEKNUM()

1 Like

If it only came last week :man_facepalming:t2::rofl:

1 Like

Thanks @ThinhDinh

Seems that date maths are not working for me…
I’m using google sheets.

Missing something?

Probably there’s a bug going around with the math column. You can try refreshing your editor tab.

image