Another option is to just use one cell and format it so that you see both the
date and the day of week:

Select column A
format|Cells|Number tab|custom category
dd/mm/yyyy dddd



Harish wrote:

Hi All

I need your little help here. I have one excel spreadsheet in which in
column A I enter the date and in column B I want some formula or VBA code to
tell me which Day it is.

For Example:
Column A Column B
01/04/2007 TUESDAY
12/05/2007 SATURDAY
30/05/2007 WEDNESDAY
16/06/2007 SATURDAY
19/07/2007 THURSDAY

Your help would be greatly appreciated.
Kind Regards
Harish

--

Dave Peterson