Excel2007 the integer into the date of the month

① I opened before the tutorial courseware prepared, easy for everyone to learn, the following to be explained is the use of function functions to quickly complete the task assigned by the leadership.

② Click B5 Cell, enter the following function formula: =int (a5/365) & "Year" &int ((mod (a5,365))/30) & "Month" &mod (mod (a5,365),) & "Days", int means to take the whole, MoD represents the remainder, in order to facilitate beginners to learn, I followed the one-month 30-day calculation, otherwise the function formula is too complex, we can not understand.

③ get calculated results, 1148 of the results are 3 years January 23 days, 3*365+30+23=1148, correct.

④ again fills the entire table with the method of cell padding.