Adjusting Timeline with a link
 

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,

Adjusting Timeline with a link
 

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§¤" wrote:

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,

Adjusting Timeline with a link
 

Peggy,

You are a genius....Thank you very much.

Dave

"pshepard" wrote:

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§¤" wrote:

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,

Adjusting Timeline with a link
 

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


"pshepard" wrote:

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§¤" wrote:

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,

Adjusting Timeline with a link
 

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§¤" wrote:

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


"pshepard" wrote:

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§¤" wrote:

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,

Adjusting Timeline with a link
 

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 .

Thanks again Peggy.

David

"pshepard" wrote:

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§¤" wrote:

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


"pshepard" wrote:

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§¤" wrote:

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,