Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Excel Date:

Options
  • 08-06-2008 2:58pm
    #1
    Gadgetman496
    Registered Users Posts: 8,364 ✭✭✭


    Is it possible to get Excel to show the name of the day in the date formula?

    Example: 08/06/2008

    Can that be displayed as

    Sun 08 June 2008

    OR

    Sunday 08 June 2008



    -

    "Everybody is a genius. But if you judge a fish by its ability to climb a tree, it will live its whole life believing that it is stupid."



Comments

  • Options
    #2
    GerardKeating
    Registered Users Posts: 7,545 ✭✭✭GerardKeating


    gadgetman496 wrote: »
    Is it possible to get Excel to show the name of the day in the date formula?

    Example: 08/06/2008

    Can that be displayed as

    Sun 08 June 2008

    OR

    Sunday 08 June 2008



    -


    Yes, format the cell, in the custom section, "Dddd" i think


  • Options
    #3
    Gadgetman496
    Registered Users Posts: 8,364 ✭✭✭Gadgetman496


    That be it Gerard, simple when you know:)

    Cheers.


    -

    "Everybody is a genius. But if you judge a fish by its ability to climb a tree, it will live its whole life believing that it is stupid."



Advertisement