Thread: [Solved] Date driven value
View Single Post
 
Old 05-24-2011, 09:58 PM
ronocoo ronocoo is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: May 2011
Posts: 5
ronocoo is on a distinguished road
Default
Quote:
Originally Posted by macropod View Post
Hi ronocco,

it would be easier to address the issue if you posted a sample workbook. As it is, I have no idea what some of your cell references relate to.
Sorry about that. I attached a sample of the spreadsheet I'm working with.

This is my current formula: IF(AND(payment date<=field date,ABS(payment date-field date)<7),payment amount,"")

Thanks!
Attached Files
File Type: xlsx Date driven value.xlsx (16.1 KB, 16 views)
Reply With Quote