Forum Discussion

Jpalaci1's avatar
Jpalaci1
Brass Contributor
Feb 10, 2021

IF with specific date and send to user with dd/mm/yyyy format

I’m attempting to create a formula that does the following: Looks to see if it’s the first of the month and if so returns that month with year If any other day other than the first of the month re...
excel
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Feb 10, 2021

Jpalaci1 

Try this:

 

=IF(DAY(A1)=1,TEXT(A1,"mmm yyyy"),"Q"&QUOTIENT(MONTH(A1)+2,3)&"/"&YEAR(A1))

  • Jpalaci1's avatar
    Jpalaci1
    Brass Contributor
    Feb 18, 2021
    Thank you so much! That worked.

Resources