=TODAY()
 

Hello from Steved


=TODAY()

My issue is this I would like use the above as mmm-yy, yes I've formatted my
cell to do this and it does exactly as it is supposed to do, However I want
to do this for every month for example in Cell "A15" I've got Jun-07 but
would like to have the previous month ie May-07, then in Cell "A14" I want
Apr-07, then in Cell "A13" to Cell "A4" until I have the whole year entered
please. How would I go about this.

Thankyou.

=TODAY()
 

Enter dates as 01/mm/yy for each month and format as mmm-yy

Or have I misunderstood?

"Steved" wrote:

Hello from Steved


=TODAY()

My issue is this I would like use the above as mmm-yy, yes I've formatted my
cell to do this and it does exactly as it is supposed to do, However I want
to do this for every month for example in Cell "A15" I've got Jun-07 but
would like to have the previous month ie May-07, then in Cell "A14" I want
Apr-07, then in Cell "A13" to Cell "A4" until I have the whole year entered
please. How would I go about this.

Thankyou.

=TODAY()
 

With A15 = today() in a14 =(A15)-30. Grab handle and drag it up. works but
be careful to check as 30 might not be always a good count :)

"Toppers" wrote in message
...
Enter dates as 01/mm/yy for each month and format as mmm-yy

Or have I misunderstood?

"Steved" wrote:

Hello from Steved


=TODAY()

My issue is this I would like use the above as mmm-yy, yes I've formatted
my
cell to do this and it does exactly as it is supposed to do, However I
want
to do this for every month for example in Cell "A15" I've got Jun-07 but
would like to have the previous month ie May-07, then in Cell "A14" I
want
Apr-07, then in Cell "A13" to Cell "A4" until I have the whole year
entered
please. How would I go about this.

Thankyou.

=TODAY()
 

Hello Toppers

Ive got in Cell "A1" =TODAY() ( Jun-07 )

Now in Cell "A15" I've entered "A1-30" to give me May-07 Cell formatted as
mmm-yy

What Would I put in Cell "A14" to give me Apr-07 please

Thanks for your time.


"Toppers" wrote:

Enter dates as 01/mm/yy for each month and format as mmm-yy

Or have I misunderstood?

"Steved" wrote:

Hello from Steved


=TODAY()

My issue is this I would like use the above as mmm-yy, yes I've formatted my
cell to do this and it does exactly as it is supposed to do, However I want
to do this for every month for example in Cell "A15" I've got Jun-07 but
would like to have the previous month ie May-07, then in Cell "A14" I want
Apr-07, then in Cell "A13" to Cell "A4" until I have the whole year entered
please. How would I go about this.

Thankyou.

=TODAY()
 

=DATE(YEAR(A15),MONTH(A15)-1,DAY(A15)) in A14, and copy upwards.
--
David Biddulph

"Steved" wrote in message
...
Hello from Steved


=TODAY()

My issue is this I would like use the above as mmm-yy, yes I've formatted
my
cell to do this and it does exactly as it is supposed to do, However I
want
to do this for every month for example in Cell "A15" I've got Jun-07 but
would like to have the previous month ie May-07, then in Cell "A14" I want
Apr-07, then in Cell "A13" to Cell "A4" until I have the whole year
entered
please. How would I go about this.

Thankyou.

=TODAY()
 

Try this formula in all of your cells, A4 through A15.

=DATE(YEAR($A$1),MONTH($A$1)-16+ROW(),DAY($A$1))

HTH,
Elkar


"Steved" wrote:

Hello Toppers

Ive got in Cell "A1" =TODAY() ( Jun-07 )

Now in Cell "A15" I've entered "A1-30" to give me May-07 Cell formatted as
mmm-yy

What Would I put in Cell "A14" to give me Apr-07 please

Thanks for your time.


"Toppers" wrote:

Enter dates as 01/mm/yy for each month and format as mmm-yy

Or have I misunderstood?

"Steved" wrote:

Hello from Steved


=TODAY()

My issue is this I would like use the above as mmm-yy, yes I've formatted my
cell to do this and it does exactly as it is supposed to do, However I want
to do this for every month for example in Cell "A15" I've got Jun-07 but
would like to have the previous month ie May-07, then in Cell "A14" I want
Apr-07, then in Cell "A13" to Cell "A4" until I have the whole year entered
please. How would I go about this.

Thankyou.

=TODAY()
 

Excellent I thankyou all

Yes You have got I required.

"David Biddulph" wrote:

=DATE(YEAR(A15),MONTH(A15)-1,DAY(A15)) in A14, and copy upwards.
--
David Biddulph

"Steved" wrote in message
...
Hello from Steved


=TODAY()

My issue is this I would like use the above as mmm-yy, yes I've formatted
my
cell to do this and it does exactly as it is supposed to do, However I
want
to do this for every month for example in Cell "A15" I've got Jun-07 but
would like to have the previous month ie May-07, then in Cell "A14" I want
Apr-07, then in Cell "A13" to Cell "A4" until I have the whole year
entered
please. How would I go about this.

Thankyou.

=TODAY()
 

Try this:

The formula below is required Analysis Toolpak Add-ins

A15 =EDATE($A$1,ROW()-16)

Drag the Fill Handle up as far as needed


"Steved" wrote:

Hello Toppers

Ive got in Cell "A1" =TODAY() ( Jun-07 )

Now in Cell "A15" I've entered "A1-30" to give me May-07 Cell formatted as
mmm-yy

What Would I put in Cell "A14" to give me Apr-07 please

Thanks for your time.


"Toppers" wrote:

Enter dates as 01/mm/yy for each month and format as mmm-yy

Or have I misunderstood?

"Steved" wrote:

Hello from Steved


=TODAY()

My issue is this I would like use the above as mmm-yy, yes I've formatted my
cell to do this and it does exactly as it is supposed to do, However I want
to do this for every month for example in Cell "A15" I've got Jun-07 but
would like to have the previous month ie May-07, then in Cell "A14" I want
Apr-07, then in Cell "A13" to Cell "A4" until I have the whole year entered
please. How would I go about this.

Thankyou.