Date and Time format for extracted value

[william_joe]

Extract date from a date and time
Formula 1: =INT(B3)
Formula 2: =TRUNC(B3)
=INT(number)
=TRUNC(number, [num_digits])
=TRUNC(B3)

Regards,
Will