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
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel Date:

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


    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

  • #2
    GerardKeating
    Registered Users, Registered Users 2 Posts: 7,806 ✭✭✭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


  • #3
    Gadgetman496
    Registered Users, Registered Users 2 Posts: 8,423 ✭✭✭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