Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
That worked... Thank you!!