| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
calculation to exclude weekends
Hi all
I wonder if someone can help me with this. I have to get my designs done 15 weeks (105 days) before the deadline. For one of my projects my deadline is 3rd Oct and I want to calculate in 1 cell what day i need to complete the project - 15 weeks before the deadline but excluding the weekends, can you help me find a formula for this? My Deadline is 3rd Oct, i should be completing the project on 28th June? how can i get excel to calculate the correct completion date? Thank you for your help Need2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
| Schedule to exclude weekends and holidays | Excel Discussion (Misc queries) | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
Threaded Mode
