ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Project Planning using Excel (https://www.excelbanter.com/excel-programming/401474-project-planning-using-excel.html)

moonhk

Project Planning using Excel
 
Hi All

Any User using excel for Project Planning ? How can you calcuate Start
date and End date base on given Start date. The calcuation not include
Sunday and Saterday. Any Suggestion ?

Example
http://www.editgrid.com/user/cxleung/Planning

moonhk
GMT+8

carlo

Project Planning using Excel
 
Check the Help for Networkdays.

hth Carlo

On Nov 21, 4:38 pm, moonhk wrote:
Hi All

Any User using excel for Project Planning ? How can you calcuate Start
date and End date base on given Start date. The calcuation not include
Sunday and Saterday. Any Suggestion ?

Examplehttp://www.editgrid.com/user/cxleung/Planning

moonhk
GMT+8



moonhk

Project Planning using Excel
 
On 11$B7n(B21$BF|(B, $B2<8a(B3$B;~(B45$BJ,(B, carlo wrote:
Check the Help for Networkdays.

hth Carlo

On Nov 21, 4:38 pm, moonhk wrote:



Hi All


Any User using excel for Project Planning ? How can you calcuate Start
date and End date base on given Start date. The calcuation not include
Sunday and Saterday. Any Suggestion ?


Examplehttp://www.editgrid.com/user/cxleung/Planning


moonhk
GMT+8- $Bp,i6Ho0zMQJ8;z(B -


- $Bp}<(Ho0zMQJ8;z(B -


Thank a lot.

carlo

Project Planning using Excel
 
On Nov 21, 4:52 pm, moonhk wrote:
On 11$B7n(B21$BF|(B, $B2<8a(B3$B;~(B45$BJ,(B, carlo wrote:





Check the Help for Networkdays.


hth Carlo


On Nov 21, 4:38 pm, moonhk wrote:


Hi All


Any User using excel for Project Planning ? How can you calcuate Start
date and End date base on given Start date. The calcuation not include
Sunday and Saterday. Any Suggestion ?


Examplehttp://www.editgrid.com/user/cxleung/Planning


moonhk
GMT+8- $Bp,i6Ho0zMQJ8;z(B -


- $Bp}<(Ho0zMQJ8;z(B -


Thank a lot.- Hide quoted text -

- Show quoted text -


You're welcome, thank you for the feedback


All times are GMT +1. The time now is 04:00 PM.

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