| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need help limiting the "now()" syntax
Hi. I need the "now()" syntax to only return the date, without the time stamp.
Is this possible? Help would be much appreciated. Many thanks -- Callan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
I need help limiting the "now()" syntax
You should wrap up now() in a format call
ie format(now(),"dd/mm/yy") returns 07/10/05 for the 7th October 2005 if you are running with English date settings. -- www.alignment-systems.com "Callan" wrote: Hi. I need the "now()" syntax to only return the date, without the time stamp. Is this possible? Help would be much appreciated. Many thanks -- Callan |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
I need help limiting the "now()" syntax
Thanks. That did the trick.
Much Appreciated. -- Callan "John.Greenan" wrote: You should wrap up now() in a format call ie format(now(),"dd/mm/yy") returns 07/10/05 for the 7th October 2005 if you are running with English date settings. -- www.alignment-systems.com "Callan" wrote: Hi. I need the "now()" syntax to only return the date, without the time stamp. Is this possible? Help would be much appreciated. Many thanks -- Callan |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
I need help limiting the "now()" syntax
Use =TODAY()
Bob Umlas Excel MVP "Callan" wrote in message ... Hi. I need the "now()" syntax to only return the date, without the time stamp. Is this possible? Help would be much appreciated. Many thanks -- Callan |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
I need help limiting the "now()" syntax
On Fri, 7 Oct 2005 02:31:09 -0700, Callan
wrote: Hi. I need the "now()" syntax to only return the date, without the time stamp. Is this possible? Help would be much appreciated. Many thanks You could use: =TODAY() =INT(NOW()) --ron |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
I need help limiting the "now()" syntax
You can format the cell where the formula is as...Time. - Kills the date and
shows only the time. "Callan" wrote: Hi. I need the "now()" syntax to only return the date, without the time stamp. Is this possible? Help would be much appreciated. Many thanks -- Callan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| correct syntax for nesting "if", "and", and "vlookup"....if possib | Excel Worksheet Functions | |||
| Limiting a Column to "X" Number of Characters | Excel Discussion (Misc queries) | |||
| Limiting a Column to "X" Number of Characters | Excel Discussion (Misc queries) | |||
| Syntax to "OR" 3 "ISERROR" conditions | Excel Worksheet Functions | |||
| what is syntax for if(between range of dates,"Q1","Q2")? | Excel Worksheet Functions | |||
Hybrid Mode
