Date driven value

		Microsoft Office Forums > Microsoft Excel > Excel
Date driven value

FAQ

Thread Tools

Display Modes

05-24-2011, 09:44 AM

ronocoo

Windows 7 64bit Date driven value

Office 2010 64bit

Novice

Join Date: May 2011

Posts: 5

Okay, this is the formula I came up with.

=IF(ABS((DAY(C$1)-$I19))>25,$J19,IF(ABS((DAY(C$1)-$I19))<5,$J19,""))

Can you help me simplify it? I'd like to combine finding >25 or <5.

« 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 01:36 PM.