Forum Discussion
Solved
Need help with inserting formula inside text please.
I did a search for this and I almost have the formula right but it's not giving me the correct output answer I need. In my spreadsheet, A3 is today's date 5/1 In another cell I have =SUM(A3+24) ...
Hi Emily,
1) Instead of =SUM(A3+24) you may simply use =A3+24
2) Numeric representation of the May 25, 2017 is 42880, i guess you receive this number in you string. Use text formatted in your date format here, i.e.
="Your " & TEXT(A3+24,"mm/dd") & " task is due today"
Hello Emily
SUM(A3+24) is superfluid. :-)
Either A3+24 or SUM(A3,24).
For your output use the TEXT() function.
="Your "&TEXT(SUM(A3,24),"D/M")&" task is due today"