Now() function with time trim

Question

So the function =Now()....is there a way I can use this and only get the date, not the time?

or is there just a function for this idea?

Answer 1

There is a Date function.

Answer 2

Dates in VBA are just floating point numbers, where the integer part represents the date and the fraction part represents the time. So in addition to using the Date function as tlayton says (to get the current date) you can also cast a date value to a integer to get the date-part from an arbitrary date: Int(myDateValue).