ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to determine the weekday in excel? (https://www.excelbanter.com/excel-discussion-misc-queries/120826-how-determine-weekday-excel.html)

Eric

How to determine the weekday in excel?
 
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 05:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com