Extract Day from a Date

[charllie]

Hi All

I am sure this has already been covered but i cannot seem to find it anywhere by searching, so apologies if this is a repeated request.

In column "B" i have a list of dates which are formatted to display as "25/07/2018".
In column "C" i have the formula "=TEXT(B2,"dddd"). This displays the same date as a day (Wednesday).

So i am left with 2 columns where one shows the actual date and one shows the day for that date.

My problem is that when a cell in column "B" is left blank/has no date in it the adjacent cell in Column "C" is displaying as a Saturday. I want it to be blank as there is no day in there. This is because further down the line i am using a "countif" calculation to record how many occurrences of a Monday, Tuesday happen etc.

I have tried the "iferror" function but cannot get it to work.

Does anyone have any ideas that could help. I would appreciate your help.

Thanks

Charllie

 

[nemmi69]

try =IF(B2<>"",=TEXT(B2,"dddd"),"")

 

[charllie]

Hi Nemmi69

Than you for the speedy response. I had to remove the "=" before the TEXT bit as was getting an error, but once that was done it worked a treat.

I did look at an if statement but it didn't work for me, although i only used ">" and not "<>" as in your formula.

Thank you very much for your help, i really appreciate your time.

 

[nemmi69]

sorry, that was my error on the "=" The "<>" means not equal. You could reverse it all to check if it equals nothing ("") =IF(B2="","",TEXT(B2,"dddd"))