Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date
I am using =((G2-E2)364,"YES"," "), where G2 has =TODAY() in it and the E
column has the dates to be compared. All this in order to determine if a year has gone by between the dates in G2 and the dates in column E. My problem is that I want to copy the formula to the rest of the cells in column E but it gives me an #value error, it copies the formula with relative values... What I want is to be able to weed out the records that are 364 or more days old. Thanks in advanced. Hernan Vergara |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions |