Hi there,

In my excel sheet I have a column with dates (deadlines), with a checkbox in a column next to it that is checked once a deadline has been met or the activity corresponding to the deadline has been done. What I would like to do is:

1) Have the date change from the current year to the next year (e.g. Deadline is on 31/12/2012. Once checkbox in next column is ticked, column with deadline will change from 31/12/2012 to 31/12/2013)

2) Subsequently, have the checkbox become un-checked once the ACTUAL year has gone. (e.g. at the end of this year, the checkbox will automatically un-check itself, so it can be checked again once the activity is done in 2013)

Is this possible?

Thanks in advance!