Hey guys,
I was wondering what the best formula would be to have a cell populate with the day of the week based on another cell having the date.
Example:
A2 = March 27, 2014
B2 = Thursday
I am currently using this formula:
=CHOOSE(WEEKDAY(B19),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")
The problem I have is that if there is no date in the cell it will automatically show "Saturday". Is there anyway to have it just be blank?
Thanks.
Maybe this? (untested)
=if(B19="","",CHOOSE(WEEKDAY(B19),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"))
Why not just format the cell to show the weekday though? Try custom format "dddd", instead of that big formula
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
Thanks.
That formula works great.
Did you consider just using format instead
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks