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
Bookmarks