Custom Date formula needed

  • Thread starter Thread starter Yogi_Bear_79
  • Start date Start date
Y

Yogi_Bear_79

I need a formula that returns true is the date in cell C1 is in the next 4
weeks. The catch is this week can not count. So, if today is 7 june 05. I
need the code to be true if the date in C1 is between 12 June 05 ~ 9 July
05.
 
Try:

=AND(C1>TODAY()+7-WEEKDAY(TODAY()),C1<=TODAY()+35-WEEKDAY(TODAY()))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate elapsed time excluding specific timeframe 10
Summing weekly values to fall into correct month 2
Mapping strings to integers 5
Help with week day count with range 6
Cumulative sum on Condition (Horizontally) 5
Workday Formula to include date 0
Help with Excel 2007 COUNTIFS! 0
Formula 2

Back
Top