| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculating the first day of the week
Just to add......
In the formula I use {"B","E","M"} These need to be in that order (alphabetical) for the formula to work. You migt want to split the formula in two to show B, E or M in M2, i.e. =VLOOKUP(J2,Sheet2!A2:H43,MATCH(K2,Sheet2!A1:H1,0) ,0) and to calculate the revised figure in N2 with =IF(M2="B",-30,IF(M2="M",-5,IF(M2="E",10)))+L2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto calculate day of week to week of the year (not as serial) | Excel Discussion (Misc queries) | |||
| calculating a date using the day of the week as a starting point? | Excel Worksheet Functions | |||
| Calculating a colmun to total a 40 hour work week | Excel Worksheet Functions | |||
| Calculating total work week hours | Excel Worksheet Functions | |||
| I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
![barry houdini[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
