PC Review


Reply
Thread Tools Rate Thread

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?
 
Reply With Quote
 
 
 
Reply

Thread Tools
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


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:14 AM.