ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Now() (https://www.excelbanter.com/excel-worksheet-functions/143072-now.html)

fgwiii[_2_]

Now()
 
I need to use the Now function, but I need it to return just the date -
without the time.

Thanks,

Fred

RFJ

Now()
 
=today()

"fgwiii" wrote in message
...
I need to use the Now function, but I need it to return just the date -
without the time.

Thanks,

Fred




Niek Otten

Now()
 
Hi Fred,

=TODAY()

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"fgwiii" wrote in message ...
|I need to use the Now function, but I need it to return just the date -
| without the time.
|
| Thanks,
|
| Fred




All times are GMT +1. The time now is 07:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com