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 |