| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
If formula with 12 conditions
I have a date column and I want another column to sort only by the month of
the date column. So I want column B to look at column A and only read the month - then translate it to a number. If the first 2 numbers in (a2=01 then b3=1 , or a2=02 then b3=2, or a2=03 then b3=3.... ect) Can this be done? |
|
#2
|
|||
|
|||
|
Hi
You could try something like =TEXT(A2,"mm") in B3. Or simply =MONTH(A2) -- Andy. "tkacoo" wrote in message ... I have a date column and I want another column to sort only by the month of the date column. So I want column B to look at column A and only read the month - then translate it to a number. If the first 2 numbers in (a2=01 then b3=1 , or a2=02 then b3=2, or a2=03 then b3=3.... ect) Can this be done? |
|
#3
|
|||
|
|||
|
Thank you... you are awesome!!!!
used =MONTH(A2) Worked perfect!!! "Andy B" wrote: Hi You could try something like =TEXT(A2,"mm") in B3. Or simply =MONTH(A2) -- Andy. "tkacoo" wrote in message ... I have a date column and I want another column to sort only by the month of the date column. So I want column B to look at column A and only read the month - then translate it to a number. If the first 2 numbers in (a2=01 then b3=1 , or a2=02 then b3=2, or a2=03 then b3=3.... ect) Can this be done? |
|
#4
|
|||
|
|||
|
Thanks for the feedback! Glad to help.
-- Andy. "tkacoo" wrote in message ... Thank you... you are awesome!!!! used =MONTH(A2) Worked perfect!!! "Andy B" wrote: Hi You could try something like =TEXT(A2,"mm") in B3. Or simply =MONTH(A2) -- Andy. "tkacoo" wrote in message ... I have a date column and I want another column to sort only by the month of the date column. So I want column B to look at column A and only read the month - then translate it to a number. If the first 2 numbers in (a2=01 then b3=1 , or a2=02 then b3=2, or a2=03 then b3=3.... ect) Can this be done? |
|
#5
|
|||
|
|||
|
Hope your still here... I have one more condition...
If the A2 is blank, b3 should be blank ... "Andy B" wrote: Thanks for the feedback! Glad to help. -- Andy. "tkacoo" wrote in message ... Thank you... you are awesome!!!! used =MONTH(A2) Worked perfect!!! "Andy B" wrote: Hi You could try something like =TEXT(A2,"mm") in B3. Or simply =MONTH(A2) -- Andy. "tkacoo" wrote in message ... I have a date column and I want another column to sort only by the month of the date column. So I want column B to look at column A and only read the month - then translate it to a number. If the first 2 numbers in (a2=01 then b3=1 , or a2=02 then b3=2, or a2=03 then b3=3.... ect) Can this be done? |
|
#6
|
|||
|
|||
|
Hi
Try this: =IF(A2<0,MONTH(A2),"") -- Andy. "tkacoo" wrote in message ... Hope your still here... I have one more condition... If the A2 is blank, b3 should be blank ... "Andy B" wrote: Thanks for the feedback! Glad to help. -- Andy. "tkacoo" wrote in message ... Thank you... you are awesome!!!! used =MONTH(A2) Worked perfect!!! "Andy B" wrote: Hi You could try something like =TEXT(A2,"mm") in B3. Or simply =MONTH(A2) -- Andy. "tkacoo" wrote in message ... I have a date column and I want another column to sort only by the month of the date column. So I want column B to look at column A and only read the month - then translate it to a number. If the first 2 numbers in (a2=01 then b3=1 , or a2=02 then b3=2, or a2=03 then b3=3.... ect) Can this be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
| Count If Formula for multiple conditions?? How To?? | Excel Worksheet Functions | |||
| Concatenating two conditions in a "IF" Formula. | New Users to Excel | |||
| Help for a formula using two conditions | Excel Worksheet Functions | |||
Linear Mode
