M
Mosaddeq Aziz
hi all,
can anyone tell me which formula shows the value of a date?
Mosaddeq
can anyone tell me which formula shows the value of a date?
Mosaddeq
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
muddan madhu
is this u r trying say ?
=DATEVALUE("29-NOV-08")
=DATEVALUE("29-NOV-08")
D
Dave Peterson
=today()
will always update to show today's date.
will always update to show today's date.
S
Shane Devenshire
Hi,
It's not clear what you are asking!
But to show the value of a date you don't need a formula, change the format
of the cell from Date to General.
If this helps, please click the Yes button
Cheers,
Shane Devenshire
It's not clear what you are asking!
But to show the value of a date you don't need a formula, change the format
of the cell from Date to General.
If this helps, please click the Yes button
Cheers,
Shane Devenshire
M
Mosaddeq Aziz
thanks. it works.
is this u r trying say ?
=DATEVALUE("29-NOV-08")
is this u r trying say ?
=DATEVALUE("29-NOV-08")