Month and Year Formula

[Yvia]

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")

[Ron_Daniel]

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"

)

[Yvia]

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 · Accepted solution]

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"

)

[Yvia]

Thanks Ron!