Adjusting Timeline with a link

  • Thread starter ¤§Tarzan§¤
  • Start date
Â

¤§Tarzan§¤

Hi all,

I'm trying to adjust a timeline by adjusting just the start date...can any
one please help me with a formula to do so (producing next month on the next
cell in reference to the previous month in the previous cell)?

eg
start date: Aug-07
Timeline: Aug-07 Sep-07 Oct-07 Nov-07 Dec-07 Jan-08 Feb-08 Mar-08.....

adjusted start date: Nov-07
Adjusted Timeline: Nov-07 Dec-07 Jan-08 Feb-08 Mar-08 Apr-08 May-08
Jun-08.....

Cheers,
 
P

pshepard

Hi,

Enter start date into A1, then copy the following formula in A2 through A12:

DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))

Let me know if this helps.

Thanks,
Peggy
 
Â

¤§Tarzan§¤

To further continue with the above:

If I had a Timeline, i would like to locate a cell adjacent to a particular
date in order to start a flow of data...is there a formula for that?

eg
scenario required: data = 4.5% from Aug-07
A B
1. May-07
2. Jun-07
3. Jul-07
4. Aug-07 4.5%
5. Sep-07 4.5%
6. Oct-07 4.5%

scenario2 required: data = $593,299 at Jun-07
A B
1. May-07
2. Jun-07 $593,299
3. Jul-07
4. Aug-07
5. Sep-07
6. Oct-07

Thanks heaps,


Dave
 
P

pshepard

Hi Tarzan,

These formulas will leave the cell blank if not true:

=IF(AND(MONTH(A1)>=8,YEAR(A1)>=2007),4.5%,"")

=IF(AND(MONTH(A1)=6,YEAR(A1)=2007),593299,"")

Let me know if this helps.

Thanks,
Peggy
 
Â

¤§Tarzan§¤

Thank you once again...

I think you are too good with Excel for me to let you go...
Am I able to contact you directly next time for more excel help? My email
address is (e-mail address removed).

Thanks again Peggy.

David
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top