3 replies
by liz montague Accepted solution
by oldbaritone Accepted solution
Just highlight the columns that are supposed to be dates, and change their format to "Date" and whatever style you want.
Internally, Excel stores all dates and times as a number. The integer part is the day, and the fractional (decimal) part is the time, as a fraction of a 24-hour day. Once you learn how it works, you'll see that it's very easy to add and subtract dates.
=Now() is right now.
=Now() + 1 is this exact time tomorrow.
=Now() - 0.5 is twelve hours ago.
and the same applies to any date/time field.
Two important points -
you MAY SUBTRACT one date from another to find the difference between them,
and you MAY ADD OR SUBTRACT a number of days, but
ADDING TWO DATES is MEANINGLESS, as are MULTIPLICATION or DIVISION.
(unless you REALLY know what you're doing!)
by liz montague Accepted solution
I already tried the obvious solutions, such as highlighting the column and changing to date. That is not working. I've worked with Excel for years but have never encountered this. For instance, in the command line the date shows 4/16/2010 but in the cell it shows 40284.
Any other ideas?
Liz
This discussion is closed to new replies.
Trending Software posts
Sort by Trending