|You appear to have mixed up the "years" in your question. You asked about 2013 but the dates you use are all 2014. In addition, your math is wrong.|
If A1 contains 30-Dec-2014, then A1+14 days = 13-Jan-2015, not 2014.
In any case, I believe this formula will work for any date, in any year, where A1+14 pushes the resulting date into the following year.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03