| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to determine the weekday in excel? | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| What formula do I use in Excel to determine whether one cell fall. | Excel Worksheet Functions | |||
| How to determine programatically if Excel is installed | Excel Discussion (Misc queries) | |||
| weekday display in excel | Excel Worksheet Functions | |||
Linear Mode
