🗓 Month, Day, and Year Math Functions

[darder]

@darder

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

Missing something?

Hi @Mark

Could you please take a look at this?

It seems date formulas are not working for me… I have tried in different sheets with the same results… nothing.

A bug or am I missing something…?

Thanks

[ThinhDinh]

Does the capital M at the start make any difference?

[Jeff_Hager]

What do you have for a value in your Date column?

[Robert_Petitto]

It shouldn’t matter. I think it’s the math column bug and needs a refresh. Even when I just made this column right now, One of my other columns (a link column even?!) became visibly empty.

[ThinhDinh]

Same here, I still experienced this today.

[darder]

[Mark]

@darder Could you share your app and tell me where you’re adding that column?

[darder]

Thanks @Mark sending you a PM…

[Mark]

This will be fixed on Thursday.

[spencersRus]

Is there a way to get the number of the day of the year?

For instance today would be 31+24=55

the day(d) just returns a 24 for the day of the month.

[Jeff_Hager]

@spencersRus

Find the last day of the following month

Try this: FLOOR(275 * MONTH(date) / 9) - (FLOOR((MONTH(date) + 9) / 12) * (1 + FLOOR((YEAR(date) - 4 * FLOOR(YEAR(date) / 4) + 2) / 3))) + DAY(date) - 30 Don’t ask how it works, because I don’t know. Found it here. https://www.epochconverter.com/daynumbers Also found some other formulas on other sites, but didn’t quite understand how to make it work in glide. I thought I would maybe need a seed date column with a Jan 1st to calculate from, but this way works without a seed date.

[Darren_Murphy]

It’s the gift that just keeps on giving

[Jeff_Hager]

I think it’s time to start organizing all of these formulas into an app. The list is growing!

[Food2Soil]

Is there a function to get the name of the month from a date? I can do it in google sheets but would be cleaner if I could add a column in glide data.

[david]

@Food2Soil

Is there a function to get the name of the month from a date?

[Food2Soil]

cccc gives me weekday. whats the format for month name. is there a list somewhere of all available formats. thanks much!

[david]

Oh oops! luxon - Immutable date wrapper

[Food2Soil]

yay! thankyou!

[Darren_Murphy]

Slightly more verbose, but here is how I do it:

• I have a table that lists the month names in a single column
• I use a math column to determine the month number from the date Month(date)-1
• I then use a single value column to “fetch” the correct month name, using the “from start” option, and feeding that the output of the math column

The only reason I offer this option is because I’m aware that the Date Format plugin has been known to fail with some combinations of user locale and/or date format.

[Food2Soil]

thankyou!