🗓 Month, Day, and Year Math Functions

Ask for Help
1

Woohoo!

Month(), Day(), Year()

Now we just need hour, minute and second?

image
image2208×1242 200 KB

16 Likes
2

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

15 Likes
3

Seriously. This is super helpful!

3 Likes
4

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

image
image787×1399 113 KB

5 Likes
5

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

7 Likes
6

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

2 Likes
7

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

2 Likes
8

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

1 Like
9

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:

10

Yep! Getting it from the date column!

11

Ah. It was a Glide table. :see_no_evil:

1 Like
12

This is great

13

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

14

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

15

But in excel? This wouldn’t be new…

16

No you do this in a math column.

1 Like
17

+1 for WEEKNUM()

1 Like
18

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

1 Like
19

Thanks @ThinhDinh

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

Missing something?

image
image1167×1422 216 KB

20

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

image