Hi I have a cell with the following formula

="As of "& TEXT(Sheet1!B15,"mmmm d, yyyy")

The Conftents are showing As of January 0, 1900

- I formatted the cell as date

and the date being referenced is in Sheet1 as

=WORKDAY(TODAY(),-1)

how Can I get the date I need to show?

its being copied and pasted in a Macro (the As of ) cell is maybe the format i am pasting in the issue?