Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=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. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=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. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF TODAY equals date in cell A10, or if TODAY is beyond that date | Excel Worksheet Functions | |||
TODAY() | Excel Worksheet Functions | |||
Today()-1 | Excel Discussion (Misc queries) | |||
=today() | Excel Worksheet Functions | |||
=IF(OR(TODAY() |
Excel Discussion (Misc queries) |