Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 05-24-2011, 09:58 PM
ronocoo ronocoo is offline Date driven value Windows 7 64bit Date driven value Office 2010 64bit
Novice
Date driven value
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to Create a Resource Driven Schedule gamer83 Project 2 05-24-2011 03:56 AM
Date driven value Creating a date box Philip290 Excel 5 05-11-2011 03:27 AM
Date driven value A date question markg2 Excel 3 11-05-2010 02:35 PM
new appointment date always reverts back to today's date msills Outlook 0 08-24-2007 08:57 AM
Date driven value Imported message date change to today's date promark Outlook 1 12-23-2005 07:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:23 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft