Formula to display full month name if a formula in a cell represents the first day of the month

[klitton7]

I am preparing templates for our payroll software for various work schedules.
See attached. If cells JQ3 and KU3, contain a "1" (which is actually formatted to displaying the "day" section of the month), then I would like the long version of the corresponding month name to appear on Row 1 above the "1"

 

[Fluff]

How is the JQ3 formatted to show the day?

 

[klitton7]

Custom format - Type = d

 

[RoryA]

You could use:

=IF(DAY(JQ3)=1,TEXT(JQ3,"mmmm"),"")

 

[klitton7]

Works great! Thank you!