| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 108055 | 2010-03-12 04:54:00 | Excel formula query - help appreciated please. | John W (523) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 866304 | 2010-03-12 04:54:00 | Hi there. Id like to create 10 daily consequitive time sheets, where the displayed date on all sheets is a working day, (ie - Mon to Friday) only. Essentially, there are 20 rows to each page, repeated down the length of the spreadsheet, at R1C1 the start date is entered, R21C1 displays the next work day. R41C1 displays two days out, etc down the length of the page. But, I dont know the formula to avoid a weekend day appearing in the date entry column. As well, how do I avoid a weekend day being displayed in rows below (R21C1, R41C1 etc..) Ideas and or formula appreciated. Many thanks John in Mosgiel. |
John W (523) | ||
| 866305 | 2010-03-12 05:14:00 | I think you can hide rows, or perhaps use auto filter to not display rows you don't want... | kahawai chaser (3545) | ||
| 866306 | 2010-03-12 05:16:00 | This may be a bit oversimplified but R1 is a Monday and R21 = R1+1, R41=R21+1 and so on, when you get to R101 it equals R81+3 and the R121=R101+1 | TeejayR (4271) | ||
| 866307 | 2010-03-13 08:45:00 | Hi John, see the Weekday formula. As an example, assuming A1 contains a date then in A2 you would have the following formula which you can drag down to subsequent rows... =IF(WEEKDAY(A1+1,2)=6,A1+3,IF(WEEKDAY(A1+1,2)=7,A1 +2,A1+1)) regards, Graham |
Parry (5696) | ||
| 1 | |||||