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?
January 0, 1900 is the equivalent of 0.
=WORKDAY(TODAY(),-1)
returns 07 Aug 2015 for me which is correct.
You'rer probably referring to the wrong cell.
What's in B15 for that matter?
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Your Right, it was supposed to be cell B3.
It works!
Marking this as solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks