Thread: formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kay Kay is offline
external usenet poster
 
Posts: 129
Default 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