As implied in the said article, the date is the whole number and the time is the decimal. ROUND DOWN function can be used in the same manner as the INT one. But unlike the latter, you have to specify the number of decimal figures to be left. The syntax for the RoundDown function is:
RoundDown( number, num_digits )
number is the number to round down (which refers to the cell reference)
num_digits is the number of decimals to round the number to
So if cell A1 is 7/31/2011 1:26 or 40755.06 if in number format, the formula to remove the decimal figures/timestamp is =rounddown(A1,0) . By using 0, you're telling excel that there should not be any decimal.
This is just my first. There are more easy-to-follow excel tutorials to come.
This blog is listed in linked words.com under Microsoft Excel