Change the value to date format basis the value in the cell

[Tharabai]

Hi,
Any help on my below requirement will be highly appreciated.

I want to convert the value in the column G to date format.

If the value in 0216, it should change as 15/01/2016 and 0316 then it should be 31/01/2016 and if 0416 then 15/02/2016 so on… if the value is 25/16 then it should be 31/12/2016.

 

[Deepak]

What's the logic behind that as not even the fortnightly dates are so..

 

[Marc L]

Hi !

When it's from Dumb or Dumber brain, use an IF statement for each value
or better a Select Case bloc (see in VBA inner help, beginner level) …
​

 

[Tharabai]

Hi,

It is fortnight dates but starts from 0216(15.01.2016) till 2516(24.12.2016). If i used if statement do i need to put 24 if conditions.

If it is 02 then it should be 15.01 and 03 it should be 31.01 and so on. i have not included 16 as the year vaires (may be 2015 or 16 or 17).

 

[Deepak]

Hi,

It is fortnight dates but starts from 0216(15.01.2016) till 2516(24.12.2016). If i used if statement do i need to put 24 if conditions.

If it is 02 then it should be 15.01 and 03 it should be 31.01 and so on. i have not included 16 as the year vaires (may be 2015 or 16 or 17).

then setup a table & use like as vlook up as it much easy for you too.