date value

  • Thread starter Thread starter Mosaddeq Aziz
  • Start date Start date
M

Mosaddeq Aziz

hi all,

can anyone tell me which formula shows the value of a date?

Mosaddeq
 
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
 
thanks. it works.


is this u r trying say ?

=DATEVALUE("29-NOV-08")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

show date in proper format 5
show month in text 1
group data according to month/year 1
convert to date format 3
Change back to default cell and column width. 2
How to find if the cell is emty or contains value 2
Custom data and data validation. 2
Calculate sum of product in Excel 2003 5

Back
Top