View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default How to determine the weekday in excel?

Try this:

A1=11

=WORKDAY(TODAY(),A1)
or
=WORKDAY("11/29/2006",A1)

"Eric" wrote:

Does anyone know on how to determine the date for weekday? such as
Today is wednesday 29 Nov, and I would like to determine the date by adding
11 working days from today, but not include today, and exclude all saturday
and sunday.
The answer is 14 Dec.
I will input the number of working day [11] in cell A1, and the 14 Dec is
displayed on B1.
Does anyone have any suggestion on how to code it in excel?
Thanks for any suggestions
Eric