Text & formula in 1 cell.

[Cookiemonstuh]

Im trying to Combine text and date formula to add months or days to the date. I want it to say Next payment date: mm/dd/yy the formula adds days or months to last payment date based on their pay frequency.

="Payment Date" &DATE(YEAR(J54),MONTH(J54)+1,DAY(J54))
when i enter this formula i get Payment Date41905

So i tried ="Payment Date" &DATE(YEAR(J54),MONTH(J54)+1,DAY(J54), mm/dd/yyyy)
But now it says there are too many arguements. Please HELP

[Jonmo1]

You need to use the TEXT function on the Date within the concatenated string.

="Payment Date" &TEXT(DATE(YEAR(J54),MONTH(J54)+1,DAY(J54)),"mm/dd/yyyy")

[ChemistB]

You're probably looking for

="Payment Date "&Text(DATE(YEAR(J54),MONTH(J54)+1,DAY(J54)), "mm/dd/yyyy")
or select a different format ie "mmm d, yyyy"
Does that work for you?

[Cookiemonstuh]

Awesome that worked!!! thank you!

[Jonmo1]

You're welcome.

[Speshul]

="Payment Date" &DATE(YEAR(J54),MONTH(J54)+1,DAY(J54))
="Payment Date "&DATE(YEAR(J54),MONTH(J54)+1,DAY(J54))
Also, note! The space needs to be inside the quotes for it to show in text