Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Problems in Excel
Hi Everyone, I am having problems trying to do something, when it seems so simple. I have two excel files. One excel file has all the date values and th other excel file, link to cells from the first excel file. The cells i links to are date values. I can the 2nd file to the first file. Not problem. But some problems are occuring. For example, if I don't have a date value in the first file I get th value 1/11/1900, which I don't get why that is there? Also, after I get the date value, I want to compare it to anothe value, then set the cell to a particular color. So if the date in th first file cell is 10/15/04 and the due date was suppose to b 10/14/04, the cell gets turned to red. I hope that makes sense. I will really appreciate any help in this. Thank you -- LongBeac ----------------------------------------------------------------------- LongBeach's Profile: http://www.excelforum.com/member.php...fo&userid=1539 View this thread: http://www.excelforum.com/showthread.php?threadid=27005 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel date problems | New Users to Excel | |||
date problems | Excel Discussion (Misc queries) | |||
Date problems, is it a bug??? | Excel Discussion (Misc queries) | |||
Date problems | Excel Programming | |||
Problems with Find and Date Fields in Excel macro | Excel Programming |