Next Profit Date Prediction

  • Thread starter Syed Zeeshan Haider
  • Start date
S

Syed Zeeshan Haider

Hello Experts,
I have Excel 97 Pro on Win98SE.

For a typical investment, here in Pakistan, a government bank pays the
profit to the investor after a certain interval of time. For a certain type
of investment scheme, the profit is paid after every 6 months.
For example, if you invested on March 23, 2003, your first profit will be
due to be paid to you on September 23, 2003 (right after six months) and
then on March 23, 2004 and so on.
Is there any function which could *easily* tell the next profit date
according to the situation given above?

I tried to write a formula by nesting many functions in each other but
messed up everything. Then I saw some VBA examples at Chip Pearson's web
site which indicated that a user can write custom functions. So I decided to
test my limited skills of VBA.
Now I have written some quite confusingly coded function which returns next
profit date for a six monthly investment like given above. As this function
works quite well but I am still curious:

Is there any function which could *easily* tell the next profit date
according to the situation given above?

As an Excel Expert, how do you take the idea of writing custom function with
VBA? Is it good idea or bad idea?

Thank you,
 
T

Trevor Shuttleworth

If the date were in cell G27, the following formula will add 6 months to the
date:

=DATE(YEAR(G27),MONTH(G27)+6,DAY(G27))

Drag the formula across for six monthly intervals according to your
requirements indicated below.

Regards

Trevor
 
B

Bob Phillips

Why not use worksheet functions. Assume an investment date in A1, 6 months
on is

=DATE(YEAR(A1),MONTH(A1)+6,DAY(A1))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
S

Syed Zeeshan Haider

I could do it very easily but it is not that simple how it looks like. I
meant next profit date not the date after 6 months.

Thanks for concerning!
 
S

Syed Zeeshan Haider

in message
Why not use worksheet functions. Assume an investment date in A1, 6 months
on is

=DATE(YEAR(A1),MONTH(A1)+6,DAY(A1))
Click to expand...

Next profit date coming after time Now???

Thanks,
 
L

Lady Layla

Put investment date in cell A1


: "Bob Phillips" wrote in message
: : > Why not use worksheet functions. Assume an investment date in A1, 6
: months
: > on is
: >
: > =DATE(YEAR(A1),MONTH(A1)+6,DAY(A1))
:
: Next profit date coming after time Now???
:
: Thanks,
: --
: Syed Zeeshan Haider.
: http://szh.20m.com/
:
:
: -----------------------------------
: Allah says to Mankind:
: "Then which of the favours of your Lord will ye deny?"
:
:
 
T

Trevor Shuttleworth

You asked for the date after six months and you gave an example. You got
what you asked for, specifically using your example. Put whatever date you
want in the cell. If you want to calculate 6 months from today, put
=TODAY() in the cell (but it would change every day)
 
Top