Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Month and Year Formula

Topic Labels: Formulas
Solved
Jump to Solution
2166 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Yvia
6 - Interface Innovator
6 - Interface Innovator

Hi Everyone!

So I would like a formula field where it shows the month and year of the End Date match the month and year today, say "This Month". I only know month and year separately as shown below however, I want them together in a single-sentence formula. 

IF( MONTH({END Date}) = MONTH(TODAY()),"This Month")
IF( YEAR({1st Payment Date}) = YEAR(TODAY()),"This Year")
1 Solution

Accepted Solutions
Ron_Daniel
8 - Airtable Astronomer
8 - Airtable Astronomer

That would be the same formula, just changing the month-checking field from "END Date" to "1st Payment Date" :

IF(
MONTH({1st Payment Date}) = MONTH(TODAY()),
IF(
YEAR({1st Payment Date}) = YEAR(TODAY()),
"Yes, same month and year",
"Same month, different year"),
"Not same month"
)
Screen Shot 2023-02-02 at 11.11.02 AM.png

See Solution in Thread

4 Replies 4
Ron_Daniel
8 - Airtable Astronomer
8 - Airtable Astronomer

Yvia, try this formula:

IF(
MONTH({END Date}) = MONTH(TODAY()),
IF(
YEAR({1st Payment Date}) = YEAR(TODAY()),
"Yes, same month and year",
"Same month, different year"),
"Not same month"
)
Screen Shot 2023-02-02 at 10.42.50 AM.png
Yvia
6 - Interface Innovator
6 - Interface Innovator

Thanks, Ron!

How about if I want to have month and year in single sentence formula for 1st payment?

IF( MONTH({1st Payment Date}) = MONTH(TODAY()),"This Month")
IF( YEAR({1st Payment Date}) = YEAR(TODAY()),"This Year")
Ron_Daniel
8 - Airtable Astronomer
8 - Airtable Astronomer

That would be the same formula, just changing the month-checking field from "END Date" to "1st Payment Date" :

IF(
MONTH({1st Payment Date}) = MONTH(TODAY()),
IF(
YEAR({1st Payment Date}) = YEAR(TODAY()),
"Yes, same month and year",
"Same month, different year"),
"Not same month"
)
Screen Shot 2023-02-02 at 11.11.02 AM.png
Yvia
6 - Interface Innovator
6 - Interface Innovator

Thanks Ron!