Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
EXTRACT 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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
EXTRACT MONTH FROM DATE
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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
EXTRACT MONTH FROM DATE
Perfect! Thank you!
SJ "T. Valko" wrote in message ... 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" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
EXTRACT MONTH FROM DATE
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "SSJ" wrote in message ... Perfect! Thank you! SJ "T. Valko" wrote in message ... 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" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Count the Value between dates
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 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Count the Value between dates
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)) -- Regards Roger Govier "Nahc" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I extract a month from Excel date? | Excel Discussion (Misc queries) | |||
Date arithmetic: adding 1 month to prior end of month date | Excel Worksheet Functions | |||
Sort month/date/year data using month and date only | Excel Discussion (Misc queries) | |||
extract the month of a date | Excel Discussion (Misc queries) | |||
How to extract month number from month name | Excel Discussion (Misc queries) |