| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulas
Cell A1 have May 5, 2006(start date)
cell A2:L2 have month from January to december In cell A3:L3 and A4:L4 I have numbers under each months in cell A5:L5 I have the fomula =A3-A4 I do this across to L3-L4 The only problem I need a formula to Make E5 which is under the month of may 1 or less than 1(it cannot go over 1) the other cells can be flexible This formula should be base one cell A1 Start date. -- KK |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
| automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
| Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
| formulas for changing formulas? | Excel Discussion (Misc queries) | |||
Threaded Mode
