View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sconstance sconstance is offline
external usenet poster
 
Posts: 3
Default Date formating yymm

I'm trying to take a start and end day and figure out how many years and
months is inbetween. Except I need the outcome to be in the format of yymm. I
can get just the number of months easy but can't figure out a way to get it
in that format.

Ex End Date - 2/1/2031 Start Date - 1/1/2008 = 277.22 months (rounded
to) 277 months

But I need the cell to return 2301 for 23 years 01 months