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.

Participate now!

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

Register Yourself Login