LinkBack URL
About LinkBacks
I have a weekday formula in cell a8.
I want to use that result in my array formula located in cell a10, but it just produces a blank cell.
It works if i do not use the weekday formula and just type the date in.
I have a weekday formula in cell a8.
I want to use that result in my array formula located in cell a10, but it just produces a blank cell.
It works if i do not use the weekday formula and just type the date in.
Last edited by aarco50; 06-25-2014 at 02:26 PM.
Hi and welcome to the forum
You do know that the formula in A8 is producing a date, not a week number?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Yes, in fact It's that date I need to use in cell a10.
However, if i type the date (instead of using the weekday() formula into a8, a10 produces the result I need.
Hope i'm making sense...
Jack
OK I am unable to see the contents of the other file, but A8 contains date AND time (is is formatted to not show time). Does the other file include time?
Tuesday, June 24, 2014
is not the same as...
Tuesday, Jun/624/14 2:49 PM
If you only want the date, use =TODAY() in I3
That was the problem...I changed I3 and everything else populated as it should.
Thank you so much for your time.
Glad we got it resolved, I have made that same mistake myself before
If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)
i saw how to click the star, but don't see how to show this "solved"
Under " Thread tools"?
Thanks for the assist Pepe
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks