View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Formula to calcuate next rate increase in #weeks

Just some passing thoughts for your posting. For possibly better responses to
stream-in, think you would need to explain clearly the underlying logics (how
would you do the calculations by hand?) and include sample data/expected
results. Also describe where each data/reference table lies (in which
range(s), in which sheet - what's the sheetnames, etc)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Rosemarie" wrote:
How do I create a formula that will automatically calculate the next rate
increase that could be 15 weeks from last rate increase (example 1/7/2009 +15
weeks =?). The formula would need to include €œJOBCODE, ENTRY_DATE AND # of
weeks to next increase (15 weeks). Can anyone help me with the development
of this macro?