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 |
All times are GMT +1. The time now is 11:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com