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?

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?

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 =?).

In Excel, a date is just a number of days from a certain starting point. It
looks different because formatting is applied, but it's a number for the
sake of calculations.

So if A1 contains any date, 15 weeks later is
=A1+15*7

Hope this helps getting things started.

Thank you!! Thank you!! Why couldn't I think of that.

"MyVeryOwnSelf" 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 =?).

In Excel, a date is just a number of days from a certain starting point. It
looks different because formatting is applied, but it's a number for the
sake of calculations.

So if A1 contains any date, 15 weeks later is
=A1+15*7

Hope this helps getting things started.