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?