Covert a Date in to a number

[Ant]

In cell b35 I have Jan-04 meaning January 2004

Now in cell G35 I want the value 300001

The 3000 will always be there but since its January, we
add the 01 for 300001

So if its February, it will be 300002 and so on tell we
reach 300012 (December)

Is their a way that a formula can look in a cell and see
that January is the first month?

Antonio

 

[JE McGimpsey]

One way:

G35: =300000 + MONTH(B35)

 

[Nimit Mehta]

You will need helper coloumn filled with 3000 in all
coloumns. In another helper coloumn you can use
function "=month(B35)" which will give you outcome 1
(Since its Jan)
In coloumn where you want 300001 use "=K1&L1". K and L
being your two helper coloumns respectively.
=month(cell) would give you the month number in the
specified Cell. and "=K1&L1" will combine texts 30003 and
1 giving you 300001.
-Nimit

 

[vtisix]

If cell A1 contains your date, then use:

=3000&text(month(A1),"00")