Date driven value

		Microsoft Office Forums > Microsoft Excel > Excel
Date driven value

FAQ

Thread Tools

Display Modes

05-24-2011, 09:58 PM

ronocoo

Windows 7 64bit Date driven value

Office 2010 64bit

Novice

Join Date: May 2011

Posts: 5

Quote:

Originally Posted by macropod

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

Date driven value.xlsx (16.1 KB, 16 views)

« Previous Thread | Next Thread »

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
Creating a date box	Philip290	Excel	5	05-11-2011 03:27 AM
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
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 08:23 AM.