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