Covert a Date in to a number

  • Thread starter Thread starter Ant
  • Start date Start date
A

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
 
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
 
Back
Top