View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Alan Calan Alan Calan is offline
external usenet poster
 
Posts: 6
Default change 12/5/2007 to 12/1/2005

I need a formula to add 2000 to the day, or the middle number between
the forward slashes, and make it the year and then make the day 1 or
15 or any number.

Can anyone help with that. One problem is sometimes it's one digit
and other times it's two. Ultimately, I'd like to graph the worksheet
with the date (month, year) as the X axis.

Alan