Hello Chaps--
query very similar to post by coomsie-
I have a date in columnA and I want to return the day of week in columnB
A!= 18/11/2016
then b1 must be Friday
but
If a1 is blank then
b1 must also be blank
But if columnA is empty then I want to leave columnB empty as well
please suggest a formula
regards
fred
Try:Formula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
thanks trevor= but it doesnt like it
I copied and pasted
=IF(A1="","",WEEKDAY(A1))
( is there somewhere where i need to9 say I am posting code in this forum??)
regards
fred
sorry--
I found that this one works
=IF(A1="";"";TEXT(A1;"dddd"))
But why doesnt yours work -
have I got something wrong in the formatting of the cell?
regards
Think I may have left out a bracket??
Looks like your Regional Settings use a semi-colon (as the separator as opposed to UK where it is a comma (,). My fault; I was thinking you wanted the week day number. Dohhhh.
Glad you got into work.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
by the way thanks for the tip about the comma and semicolon-
I have had the problem before and didnt know what to do
Frerd
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks