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 |
#2
|
|||
|
|||
Hello there,
You need to fix the G2. Put dollar signs around the reference: =IF($G$2-E2364,"Yes","") Pressing F4 key when the cursor is in the relevant bit of the formula also inserts the dollar sign. Be careful it also takes them out. Keep pressing it until there are 2 dollars. You can then copy the formula Hope this helps Judith -----Original Message----- 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 . |
#3
|
|||
|
|||
Thank you very much! :-)
Hernan Vergara "JudithJubilee" wrote: Hello there, You need to fix the G2. Put dollar signs around the reference: =IF($G$2-E2364,"Yes","") Pressing F4 key when the cursor is in the relevant bit of the formula also inserts the dollar sign. Be careful it also takes them out. Keep pressing it until there are 2 dollars. You can then copy the formula Hope this helps Judith -----Original Message----- 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 . |
Reply |
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 |