Date driven value

		Microsoft Office Forums > Microsoft Excel > Excel
Date driven value

FAQ

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 09:39 PM.