CODEWITHSUNDEEP
excel
austinmb
austinmb

Reputation: 69

Dynamically updating date in Excel

I need to create a dynamically updating date in Excel.

Right now in Cell A1 I have the text "updated through" In B1 I have the formula =Today()-1.

I join them with (&) in C1. The problem is that it is displayed as "updated through 43514" I've tried formatting the cell as a date (ie 2/19/2019) but it won't work. How can I do this, or is it even possible?

Upvotes: 2

Views: 70

Answers (1)

urdearboy
urdearboy

Reputation: 14590

Try:

=A1 & TEXT(B1, "mm/dd/yy")

Make sure cell A1 has a lagging space or you can add CHAR(32) in the middle of the above equation

Upvotes: 1

Related Questions