 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / June 2007=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. Enter dates as 01/mm/yy for each month and format as mmm-yy Or have I misunderstood? > Hello from Steved > [quoted text clipped - 8 lines] > > Thankyou. 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 :) > Enter dates as 01/mm/yy for each month and format as mmm-yy > [quoted text clipped - 16 lines] >> >> Thankyou. 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. > Enter dates as 01/mm/yy for each month and format as mmm-yy > [quoted text clipped - 12 lines] > > > > Thankyou. 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 > Hello Toppers > [quoted text clipped - 23 lines] > > > > > > Thankyou. 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 > Hello Toppers > [quoted text clipped - 23 lines] > > > > > > Thankyou. =DATE(YEAR(A15),MONTH(A15)-1,DAY(A15)) in A14, and copy upwards.  SignatureDavid Biddulph > Hello from Steved > [quoted text clipped - 11 lines] > > Thankyou. Excellent I thankyou all Yes You have got I required. > =DATE(YEAR(A15),MONTH(A15)-1,DAY(A15)) in A14, and copy upwards. > > Hello from Steved [quoted text clipped - 12 lines] > > > > Thankyou. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.