| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 33064 | 2003-05-06 04:25:00 | Excel formula | appanna (3735) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 141738 | 2003-05-06 04:25:00 | I need to determine the number of weeks between two dates. The end date is fixed and the number of days in a week is 5. The result I like to see is the number of weeks and days left over if any. Can someone help please? |
appanna (3735) | ||
| 141739 | 2003-05-06 04:52:00 | Assuming your dates are in Excel's number format, then the following formulas determines the number of days difference between the two days, and then return the number of 5 day blocks in this period, and the number of days left over. 5 day blocks "=TRUNC((<end date>-<start date>)/5,0)" extra days "=(<end date>-<start date>)-(<number of weeks>*5) Iain |
Iain Walmsley (3372) | ||
| 141740 | 2003-05-06 04:54:00 | Damn emoticons. 5 day blocks "=TRUNC{{<end date>-<start date>}/5,0}" extra days "={<end date>-<start date>}-{<number of weeks>*5} replace all the {} with rounded brackets in the formula. Iain |
Iain Walmsley (3372) | ||
| 1 | |||||