Hi,
I have below table1 (sheet1):
<tbody>
</tbody>
Table is filled in this way till 2017.
Now into tab "sheet2" into col A, I have dates:
<tbody>
</tbody>
How to add month value based on table1?
I don't want to do a lot of if....is other way? How to write simple function to fill month based on table1?
I have below table1 (sheet1):
<tbody> </tbody> |
<tbody> </tbody> | Month(C1) | Quater(D1) | Year(E1) | |||
<tbody> </tbody> |
<tbody> </tbody> | 1 | Q1 |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> | 2 | Q1 |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> | 3 | Q1 |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> | 4 | Q2 |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> | 5 | Q2 |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> | 6 | Q2 |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> | 7 | Q3 |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> | 8 | Q3 |
<tbody> </tbody> | |||
.. | .. | .. | .. | .. |
<tbody>
</tbody>
Table is filled in this way till 2017.
Now into tab "sheet2" into col A, I have dates:
Dates(A1) | Month (B1) |
24/08/2012 | 1 |
25/09/2012 | 3 |
20/12/2012 | 5 |
01/11/2013 | 6 |
03/10/2012 | 3 |
<tbody>
</tbody>
How to add month value based on table1?
I don't want to do a lot of if....is other way? How to write simple function to fill month based on table1?