Home |
Search |
Today's Posts |
#1
|
|||
|
|||
DATEVALUE OF CURRENT DATE
TRYING TO FIND FRMULA FOR DATE VALUE OF CURRENT DATE
=DATEVALUE("12/29/04") WORKS, BUT =DATEVALUE("TODAY()") DOESN'T IS THERE A SOLUTION? |
#2
|
|||
|
|||
Just use =Today()
and if you still need a formula then =DATEVALUE(TEXT(TODAY(),"mm/dd/yy")) "Jason Morin" wrote in message ... Just use: =TODAY() HTH Jason Atlanta, GA -----Original Message----- TRYING TO FIND FRMULA FOR DATE VALUE OF CURRENT DATE =DATEVALUE("12/29/04") WORKS, BUT =DATEVALUE("TODAY()") DOESN'T IS THERE A SOLUTION? . |
#3
|
|||
|
|||
Just use:
=TODAY() HTH Jason Atlanta, GA -----Original Message----- TRYING TO FIND FRMULA FOR DATE VALUE OF CURRENT DATE =DATEVALUE("12/29/04") WORKS, BUT =DATEVALUE("TODAY()") DOESN'T IS THERE A SOLUTION? . |
#4
|
|||
|
|||
=DATEVALUE(TEXT(TODAY(),"mm/dd/yy"))
WORKS GREAT!!! THANKS A BUNCH, JONBOYMFLY |
#5
|
|||
|
|||
I'm failing to see the merits of
=DATEVALUE(TEXT(TODAY(),"mm/dd/yy")) This formula is essentially formatting today's date as a text string, and then converting it back to an actual date. Please explain. Thanks. Jason -----Original Message----- Just use =Today() and if you still need a formula then =DATEVALUE(TEXT(TODAY(),"mm/dd/yy")) "Jason Morin" wrote in message ... Just use: =TODAY() HTH Jason Atlanta, GA -----Original Message----- TRYING TO FIND FRMULA FOR DATE VALUE OF CURRENT DATE =DATEVALUE("12/29/04") WORKS, BUT =DATEVALUE("TODAY()") DOESN'T IS THERE A SOLUTION? . . |
#6
|
|||
|
|||
Hi
just as a comment :-) No need for this formula. Just use the formula =TODAY() shorter, simpler and also will work in non-US countries :-) -- Regards Frank Kabel Frankfurt, Germany "JONBOYMFLY" schrieb im Newsbeitrag ... =DATEVALUE(TEXT(TODAY(),"mm/dd/yy")) WORKS GREAT!!! THANKS A BUNCH, JONBOYMFLY |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock in current date | Excel Discussion (Misc queries) | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
How do I program a cell to automaticinput the current date as dat. | Excel Worksheet Functions |