EXTRACT MONTH FROM DATE

[SSJ]

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

 

[T. Valko]

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


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

 

[SSJ]

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


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

 

[T. Valko]

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


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


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

 

[Nahc]

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

 

[Roger Govier]

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))