Thread: Weekday
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Weekday

Not that I'm aware of.

A1: Enter the DATE of a Sunday (such as 7/23/2006) and format it to "dddd"
B1: =A1+5 ... also format to "dddd"

HTH,
Barb Reinhardt


"LB79" wrote:


Hello - im having trouble trying to do something.
I have a worksheet and in cell A1 i type Sunday. I want cell B1 to add
five days on and return the day name.

Is there a way to do this?

Thanks


--
LB79
------------------------------------------------------------------------
LB79's Profile: http://www.excelforum.com/member.php...o&userid=12156
View this thread: http://www.excelforum.com/showthread...hreadid=565967