Obtain the day from a date

[pharvey]

Does anyone know how I can obtain the actual day from a date in Excel. I want to create an ongoing list of days from a calendar within Excel.

 

[Joe4]

Format the cell as "dddd" to get the day.

Or if you want to leave the original date and show the day in another cell, if your date is in A1, then use this formula:

=TEXT(A1,"dddd")

 

[TommyGun]

Or to just retrieve the integer value of the date...

=Day(A1)

 

[pharvey]

That's superb - I never expected such an immedaite response - works too - I've spent 2 hours trying to work it out, then in desperation I discovered your site - again many thanks