Date Formatting

[KJP0422]

How would I get this to formula to add "CP - " and the month name from the EOMONTH function

My desired end result would read CP - 1: Apr assuming the current month = May

=EOMONTH(NOW(),-1)

=CONCATENATE("CP - 1:",EOMONTH(NOW(),-1), mmm)

is returning #NAME?

Thanks for you help in advance

 

[Weazel]

maybe something like..

="cp - 1 : "&TEXT(EOMONTH(NOW(),-1),"mmmm")

 

[KJP0422]

Perfect. Thanks for the formula and more importantly Thanks for you service. My father was also in the 101.