date and time

  • Thread starter Thread starter ladimples247
  • Start date Start date
L

ladimples247

I need some help. I'm trying to put a formula in a cell to ready onl
the date. When i set the date and type in 02162005 it gives me a dat
for 5/14/19. how can I fix it for it to show todays date in that on
cell. Yeah i can use control, ; but i have multiple users and don
know that much of excel. so im trying to set it up for when they typ
in the date it would appear todays date or the date they want to use.
for example I want today's date 02162005 to appear as 2/16/2005 in th
cell. Help please !!!!!!!! :confused
 
you need to understand how excel treat dates and times to understand what is
happening. Without code what you want cannot be done

To understand dates/times and for the code to fix what you want, check here

www.cpearson.com/excel/datetime.htm


--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Back
Top