ExcelBanter - removing date from field

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - removing date from field (https://www.excelbanter.com/excel-programming/334639-removing-date-field.html)

LHaro

removing date from field

Hello -

I have a field that has both the date and the time in it, but what vba code
can i use to extract the date only? Thanks in advance to anyone who can help
me.

Ron de Bruin

removing date from field

Hi

Try this

Int(ActiveCell.Value)

--
Regards Ron de Bruin
http://www.rondebruin.nl

"LHaro" wrote in message ...
Hello -

I have a field that has both the date and the time in it, but what vba code
can i use to extract the date only? Thanks in advance to anyone who can help
me.

LHaro

removing date from field

Thank U so much!

"Ron de Bruin" wrote:

Hi

Try this

Int(ActiveCell.Value)

--
Regards Ron de Bruin
http://www.rondebruin.nl

"LHaro" wrote in message ...
Hello -

I have a field that has both the date and the time in it, but what vba code
can i use to extract the date only? Thanks in advance to anyone who can help
me.

All times are GMT +1. The time now is 08:28 AM.