Thread: Modifying a complex date formual to count months
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Charabeuh[_6_] Charabeuh[_6_] is offline
external usenet poster
  
Posts: 17
Default Modifying a complex date formual to count months
Hello,

You could try this formula:
=IF(ISNUMBER(B21),IF(MOD(B21,12)=1,"Year
"&0&0+INT(B21/12),REPT("0",2-LEN(2+MOD(B21-2,12))) &(
2+MOD(B21-2,12))),"")


Reply With QuoteReply With Quote