ExcelBanter - Custom Date formula needed

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Custom Date formula needed (https://www.excelbanter.com/excel-worksheet-functions/29653-custom-date-formula-needed.html)

Yogi_Bear_79

Custom Date formula needed

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.

Vasant Nanavati

Try:

=AND(C1TODAY()+7-WEEKDAY(TODAY()),C1<=TODAY()+35-WEEKDAY(TODAY()))

--

Vasant

"Yogi_Bear_79" wrote in message
...
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.

All times are GMT +1. The time now is 08:28 PM.