I need a formula that will tell me if today is a *multiple* of 7 days from a date in another cell. (To track eBay auction end dates.) So in its simplest form, is today any multiple of 7 days from the date in T3. If so, evaluate to TRUE. If not, evaluate to FALSE and make the cell blank. If there is no date in T3, make the cell blank.
So lets say that an auction was started on June 1rst at 10am. If today was any day between June 2 - 7 the cell will evaluate to false. After after midnight on the 7th, because it is now between the 7th day, the formula will evaluate to TRUE. It is fairly important that it only become TRUE on the actual date that it is the 7th day, NOT exactly 144 hours (6 days x 24 hours) from the previous date.
Now for the difficult part: I need for it to evaluate to FALSE again on the 8th - 13th day, and then TRUE again on the 14th day, just like above. And the same again on every multiple of 7 days.
Cell T3 contains the initial list date, Cell U3 will contain this formula. If no date is present in T3 then I would like U3 to be blank. Is all this possible? Office 2003 btw.
So lets say that an auction was started on June 1rst at 10am. If today was any day between June 2 - 7 the cell will evaluate to false. After after midnight on the 7th, because it is now between the 7th day, the formula will evaluate to TRUE. It is fairly important that it only become TRUE on the actual date that it is the 7th day, NOT exactly 144 hours (6 days x 24 hours) from the previous date.
Now for the difficult part: I need for it to evaluate to FALSE again on the 8th - 13th day, and then TRUE again on the 14th day, just like above. And the same again on every multiple of 7 days.
Cell T3 contains the initial list date, Cell U3 will contain this formula. If no date is present in T3 then I would like U3 to be blank. Is all this possible? Office 2003 btw.
