Date chart formula question?!?1

Scott_goddard

Guest

Posts: n/a

8th Apr 2010

Hi all,

In a very old spread sheet i was using this formula
=IF(OR(AND($D7<G$6,$E7>F$6),AND(F$6>=$D7,F$6<=$E7)),".","") and it worked for
dates pre 2009. However, i now wish to use it for dates between 2010 - 2011.
Each column represent a week and the rows will indicate and project or task.

can anyone help?

« Working Days of Week and DUE DATE for PAYMENT | Repeating rows not wanted »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date question formula	Fly Boy 5	Microsoft Access Queries	4	2nd Feb 2010 03:56 PM
DUE DATE FORMULA QUESTION	ohnesorge	Microsoft Excel Worksheet Functions	1	13th Mar 2009 07:38 PM
Dynamic Chart Formula Question	Bob@1800-mail.com	Microsoft Excel Charting	5	3rd Mar 2009 01:04 PM
Complex Date chart question	tiggers	Microsoft Excel Charting	2	23rd Jan 2009 02:31 AM
Re: Date Formula Question	JulieD	Microsoft Excel Worksheet Functions	0	25th Aug 2004 04:57 PM