View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kandy kandy is offline
external usenet poster
 
Posts: 1
Default Functions/formula

start date: 03/26/06( this is in cell k3)


Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun ( these are from cell D8:O8)
1 1 1

I need a formula that can calculate and issue the number 1 every four months
as above; using the start date to issue the first one.