Sean,
You can probably do this with one formula, but I split it into 2 formulas in the interest of time.
For the first date, use this formula (entered into b1):
=datevalue(a1&" 2002")
The second formula (in the cell below this one) would be:
=b1+1
The custom date format should be:
ddd MMM dd
Like this thread? Share it with others