Entering Day after date

[sakoni2001]

Hi

I am very new to programming in Excel and I need help.

I have a large worksheet. Column A1 has date as 25 March 2007. I need to add column B and enter the Day eg., Sunday.

Could someone please advise me on how I can do this. I have over 100 dates which need converting.

Many thanks in advace

[Simon Lloyd]

Welcome to Excelforum! if you don't need to use column B just format the cell in column A to your requirement, right click the cell choose format and then from the list choose Custom you will see the word General above a list on the right hand side click here and type dddd mmmm yyyy and then click ok.
If you need to use column B you can use =A1 then press enter, right click the cell and choose format as above follow the same proceedure but type dddd instead, now whichever date appears in A1 the day of that date will appear in B1.

Regards,
Simon

[VBA Noob]

Hi,

Here's a couple of VBA ways

1st assumes there all dates
2nd checks to see if it's a date

Please Login or Register  to view this content.

Please Login or Register  to view this content.

VBA Noob

[sakoni2001]

Hi Simon & VBA Noob

Thank you very much for that. Works a treat.

Best regards

[Simon Lloyd]

Glad you got sorted!

Regards,
SImon

[VBA Noob]

Same here.

VBA Noob