 |
 | 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 / New Users / March 2008EXTRACT MONTH FROM DATE
Hello, I am using the following formula to extract month from the date: =month(a1) The result is 1 What I wan to see is Jan instead of 1. Also what do I need to do if I want the result as Jan-08 Thanks SJ Try one of these: =TEXT(A1,"mmm") That will return the short month name as a TEXT value = Jan =TEXT(A1,"mmm-yy") Will return the TEXT value Jan-08  SignatureBiff Microsoft Excel MVP -- Biff Microsoft Excel MVP Hello, I am using the following formula to extract month from the date: =month(a1) The result is 1 What I wan to see is Jan instead of 1. Also what do I need to do if I want the result as Jan-08 Thanks SJ Perfect! Thank you! SJ Try one of these: =TEXT(A1,"mmm") That will return the short month name as a TEXT value = Jan =TEXT(A1,"mmm-yy") Will return the TEXT value Jan-08 -- Biff Microsoft Excel MVP -- Biff Microsoft Excel MVP "SSJ" <jameel68@yahoo.com> wrote in message news:egQEMRxfIHA.5348@TK2MSFTNGP03.phx.gbl... Hello, I am using the following formula to extract month from the date: =month(a1) The result is 1 What I wan to see is Jan instead of 1. Also what do I need to do if I want the result as Jan-08 Thanks SJ You're welcome. Thanks for the feedback! SignatureBiff Microsoft Excel MVP Perfect! Thank you! SJ "T. Valko" <biffinpitt@comcast.net> wrote in message news:OESLFWxfIHA.536@TK2MSFTNGP06.phx.gbl... Try one of these: =TEXT(A1,"mmm") That will return the short month name as a TEXT value = Jan =TEXT(A1,"mmm-yy") Will return the TEXT value Jan-08 -- Biff Microsoft Excel MVP -- Biff Microsoft Excel MVP "SSJ" <jameel68@yahoo.com> wrote in message news:egQEMRxfIHA.5348@TK2MSFTNGP03.phx.gbl... Hello, I am using the following formula to extract month from the date: =month(a1) The result is 1 What I wan to see is Jan instead of 1. Also what do I need to do if I want the result as Jan-08 Thanks SJ Dear Expert, I've a sheet showing In Date (1-feb-08) - 100pcs Out Date (3-feb-08) - 20pcs Out Date (6-feb-08) - 15pcs Out Date (10-feb-08) - 5 pcs Out Date (14-feb-08) - 10pcs My question is is there a formula to check a) what is my balance stock between 5-feb-08, or 12-feb-08 or any date which I may need to check. Tks / Nahc Hi With the data as you describe, it would be extremely difficult. What you need is 3 columns, and ideally to enter the quantity Out values a negative Date Quantity In Quantity Out 01/02/08 100 03/02/08 -20 06/02/08 -15 10/02/08 -5 14/02/08 -10 Then with the dates that you require the balance for entered in say cell D1 for the earliest date, and E1 for the latest date, the formula =SUMPRODUCT(($A$2:$A$100>=$D$1)*($A$2:$A$100<=$E$1)*($B$2:$C$100)) SignatureRegards Roger Govier > Dear Expert, > [quoted text clipped - 10 lines] > > Tks / Nahc
|
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.