Modifying a complex date formual to count months
Thank you for your feedback
In article , Charabeuh
writes
=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))),"")
HI
Yes - that's fantastic. It worked perfectly first time.
Thank you for your time and considerable expertise.
Best Wishes
|