Adding number of days to a TEXT date formula

[Woofy_McWoof_Woof]

Hi, I am trying to set up a formula that adds 30 days (payment due) to the date on the invoice being sent. I have being able to create the formula that references the invoice date but I can't seem to add on the extra bit that adds on the 30 additional days.

="Due Date for Payment: "&TEXT(B13,"ddd dd mmm yyyy") [B13 being the cell that contains the invoice date].

I tried referencing the cell B13 at the beginning of the formula plus 30 but this doesn't seem to work, any ideas?

Thanks for your help.

Woof

 

[Dave Patton]

T202007b.xlsm
	B	C	D	E	F
13	21-07-20	Due Date for Payment: Thu 20 Aug 2020
4d

Cell Formulas
Range	Formula
C13	C13	="Due Date for Payment: "&TEXT(B13+30,"ddd dd mmm yyyy")

or

T202007b.xlsm
	A	B	C	D	E
13	30	21-07-20	Due Date for Payment: Thu 20 Aug 2020
4d

Cell Formulas
Range	Formula
C13	C13	="Due Date for Payment: "&TEXT(B13+A13,"ddd dd mmm yyyy")

 

[Woofy_McWoof_Woof]

Oh man, so simple thank you. I didn't even think about putting it in there, it was really bugging me.

 

[Dave Patton]

Thanks for the feedback.
Glad that it works for you.