Display Day Of Week From Dates

    I have a column of dates in one column and in the next column next to the dates, I want to show the day of the week that each date represents, such as;


    Col A Col B
    1 March 2008 Sunday or Sun


    etc etc..


    I checked MS Excel help but couldn't find the exact help I needed (I could have missed it?)

    Re: Hwo To Find Day Of The Week As Text


    I didn't look at using the TEXT function. Thanks.


    I was wondering also how do I add cells together that contain calculations of time.


    I have recorded events that have lasted a period of time each day.
    I have a start time (Col C) an end time (Col D), plus the total number of hours & mins (Col E) which is D minus C, express as hours:mins.


    Simply using the sum function to add the cumulative time over one day produces an error.


    can you help with this?

    Re: Hwo To Find Day Of The Week As Text


    Quote from Firehorse

    Simply using the sum function to add the cumulative time over one day produces an error.


    Do you mean you get an error value or the wrong total? If it's the wrong total try formatting the cell with the sum as [h]:mm. The square brackets allow "elapsed time" to be displayed, i.e. totals above 24 hours

    Re: Hwo To Find Day Of The Week As Text


    Firehorse, i know this sounds a bit lame but for your other questions you will have to start a new thread! as they are a different topic, it's the rules of this forum i'm afraid!


    Glad your sorted on the date front anyway!

    Re: Hwo To Find Day Of The Week As Text


    Quote from Simon Lloyd

    Firehorse, i know this sounds a bit lame but for your other questions you will have to start a new thread! as they are a different topic, it's the rules of this forum i'm afraid!


    Glad your sorted on the date front anyway!


    I thought about that just after I pressed the submit button (yes, honest!) and I should know better anyway as I have used this forum often in the past and I have been very grateful for the help received.


    I will do so now.

    Re: Hwo To Find Day Of The Week As Text


    Hi guys,


    I have used "=TEXT(A1,"dddd") in column (B) and formatted as Dave suggested, works great, thanks guys.


    The only thing is where dates have yet to be added to the column (A), I get "Saturday" in Column B which is irritating, so I tried


    =IF(A1="",TEXT(A1,"dddd"),0)


    Lo and behold I get blank cells where there should be a day of the week and still get 'Saturday' where it should be blank cells.


    Any help will be appreciated,


    Phil.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login