Thread: Need Formula or macro. If i enter today date in the cell (Row 1,Column 2) and on tab out, the column 1 cell should be filled with "corresponding Day" of the date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
  
Posts: 3,101
Default Need Formula or macro. If i enter today date in the cell (Row 1,Co
=TEXT(B1,"ddd")

"kakasay" wrote:

HI,

Need the Formula or macro for the below description.

If i enter today date in the cell (Row 1,Column 2) and on tab out, the
column 1 cell should be filled with "corresponding Day" of the date

Thanks
kakasay


Reply With QuoteReply With Quote