| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 95447 | 2008-12-06 22:46:00 | Automatic update of days in Excel | videoguy (1351) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 726346 | 2008-12-06 22:46:00 | I want to run a 28 day calander in excel this month the 1st is a monday Next month the 1st is a Thursday I want to be able to enter thursday beside the 1st and automatically change the 2nd from a tuesday to a friday etc etc anyone know if this can be done? PS this is not a periodic table :-)) |
videoguy (1351) | ||
| 726347 | 2008-12-07 02:29:00 | In what context would you be using this? I can think of a long winded way of doing it, which would involve you needing to adjust your cell references depending on any of the 7 variations, in order to get the VLOOKUP working correctly. | the_bogan (9949) | ||
| 726348 | 2008-12-08 08:35:00 | If you key the first day of the new month in your 28 day calendar, then you can use the weekday function to get the number of the weekday - check your help file for options on which day to set as number 1. You could then use a lookup table to return the actual day - this is assuming you actually want the text form of the day. If you just want the appearance of the day, then you can set the format of the cell containing the date to 'dddd'. Andrew |
andrew93 (249) | ||
| 726349 | 2008-12-08 10:25:00 | Column A is weekday, Column B is day of month (1 to 28), Column C is weekday in numerical format. Cell A1 is weekday entry cell - enter Monday. Cell A2 to A28 are calculated weekdays - formula is =VLOOKUP(IF(C1+1>7,C1+1-7,C1+1),Wkday2,2,FALSE). Cell C1 to C28 formula is =VLOOKUP(A1,Wkday1,2,FALSE). Table wkday1 is cells I1 to J7. I1 to I7 are Monday to Saturday, J1 to J7 are 1 to 7. Table wkday2 is cells J1 to K7. J1 to J7 are 1 to 7, K1 to k7 are Monday to Saturday. |
merlin (256) | ||
| 1 | |||||