Original table
<tbody>
</tbody>
I have an excel table populated with 2 columns Date and Target where Target is a binary column which will be filled with either 1 or 0. I want to write a function such that if date is before May 3, 2014, then populate the Target column with 0. Otherwise, populate the column with 1.
Output I want
<tbody>
</tbody>
Thank you,
J
| Date | Target |
| May 1, 2014 | |
| May 2, 2014 | |
| May 3, 2014 | |
| May 4, 2014 |
<tbody>
</tbody>
I have an excel table populated with 2 columns Date and Target where Target is a binary column which will be filled with either 1 or 0. I want to write a function such that if date is before May 3, 2014, then populate the Target column with 0. Otherwise, populate the column with 1.
Output I want
| Date | Target |
| May 1, 2014 | 0 |
| May 2, 2014 | 0 |
| May 3, 2014 | 1 |
| May 4, 2014 | 1 |
<tbody>
</tbody>
Thank you,
J
