Date driven value

		Microsoft Office Forums > Microsoft Excel > Excel
Date driven value

FAQ

Thread Tools

Display Modes

05-23-2011, 06:41 PM

macropod

Windows 7 32bit Date driven value

Office 2007

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,520

Hi ronocco,

You can do the Friday test with a formula like:
=IF(MOD(A1,7)=6,"X","")
where A1 is the address of the cell containing the date of interest.

I'm not sure what you mean by "For a fixed payment on the 25th, I'd like a formula that would make that value appear on the May 27", though. Do you mean that you only want the 'X' to display on the preceding Wednesday?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« 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 03:11 AM.