# Date Based on Other Dates

• Re: Date Based on Other Dates

Timbo, You seem to be ignoring me. Never mind, thanks to filippo, I have now fixed the formula for you:

=IF(B\$8=0,MIN(DATE(YEAR(\$A11),MONTH(\$A11)+1,0),DATE(YEAR(\$A11),MONTH(\$A11),B\$10)),IF(\$B\$8=5,DATE(YEAR(A11),MONTH(A11)+1,1)-WEEKDAY(DATE(YEAR(A11),MONTH(A11)+1,DAY)),DATE(YEAR(A11),MONTH(A11),1+(\$B\$8*7))-WEEKDAY(DATE(YEAR(A11),MONTH(A11),DAY))))

• Re: Date Based on Other Dates

Kris, BTC2 and everyone else that has helped on this problem.

Many thanks it is sometimes difficult to explain exactly what you are trying to do and I think I have probably not explained this problem very very well.

In my defence I can only say that I have this awful flu bug that is going around the UK at the moment and I feel pretty lousy.

Many thanks for the solutions you have provided and apologies for any shortcomings on my behalf when trying to explain what I wanted to achieve.

Tim.

• Re: Date Based on Other Dates

Thanks Kris & everyone else who contributed.

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!