I’m creating an expense management app and I want to be able to see if the bill was already payed this month or not. Currently I have the following collumns: bill name | last payment date | amount. So I have all payments registered and want to group itens that were already payed this month. Any…

extract month and year from a date… and use IF-Else column… use a math column month (now)… year(now)

I have done something similar for an entertainment app that allows users to filter events on a specific month. My data is in Google Sheets and includes a date/time column. I created a new column in the Google Sheet with the formula =TEXT(D2,“mmmm yyyy”) where D2 is the cell reference for the date/…

in google sheets, you can use arrayformula function, in glide… a math column

[image] fluittsolutions: I have to copy down that formula into the new rows. As @Uzo said, use an Arrayformula. Then, you won’t need to copy down formulas.

You can have a read here regarding arrayformula. [image] Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts Ask for Help Hi, Today I will show you the script that can make copying formulas down work, when it d…

My approach to this, which I’ve used over and over (and over) again: Math column to extract the year: Year(Date) Math column to extract the month index number: Month(Date)-1 Single Value column to fetch the Month name (see below) Template column to stitch the month and year back together: {month…

[image] Darren_Murphy: ormat Date plugin for example, but that definitely won’t work 100% of the time. I would stay very far away from it haha. Yours definitely is a safe choice.

Filter Dates that are equal to This Month

Ask for Help

ThinhDinh March 7, 2022, 12:27am 6

You can have a read here regarding arrayformula.

Topic		Replies	Views
How can I extract the year from a date using a data column? Ask for Help	4	2067	November 30, 2020
Google sheets date functions in Glide Ask for Help	3	359	December 4, 2020
Only show rows that have date within current month Ask for Help	9	1894	February 26, 2021
Show date without year? Ask for Help	5	398	January 17, 2024
🗓 Month, Day, and Year Math Functions Ask for Help	47	3817	July 15, 2023

Filter Dates that are equal to This Month

Related topics