NPrinting Formula Help

[mikecrengland]

Hello All -

I have an NPrinting issue that's driving me crazy.

In all of my Excel reports, I create a formula to give the date of the report:

='As of ' & Date(today(),'M/D/YY')

It's always worked until today. This time, it simply displays as the tag:

The formula above it is similar:  ='For the week of ' &  Date(Cal.WeekStartMon,'M/D/YY') and it works. The number format on both cells is 'General'.

Any ideas what the heck is happening?

Thanks!

mike

[Anonymous · Accepted solution]

Does it give you the same result if you put your formula  in a different cell in your template?

Excel is very peculiar.  I can't tell you the number of times I have written formulas in Excel only to learn that the cell was formatted as text.  You have text in the two cells above it, so perhaps that is your answer.

[mikecrengland]

That worked... Thank you!!