Hi
I have a formula =if(AA2="","",edate(AA2,12)) which is working well for the Year
This is a delivery run thats requires that the pick up will aways be on a Monday.
I would like the exact day for the following years.
e.g.
Monday 2009 is the 9th March
Monday 2010 is the 8th March
Monday 2011 is the 8th March
Monday 2012 is the 6th March
Monday 2013 is the 4th March
I would appreciate it if it is possible or a alternative way of doing it.
Thanks Colin
I have a formula =if(AA2="","",edate(AA2,12)) which is working well for the Year
This is a delivery run thats requires that the pick up will aways be on a Monday.
I would like the exact day for the following years.
e.g.
Monday 2009 is the 9th March
Monday 2010 is the 8th March
Monday 2011 is the 8th March
Monday 2012 is the 6th March
Monday 2013 is the 4th March
I would appreciate it if it is possible or a alternative way of doing it.
Thanks Colin