help needed

[uul]

Hi,

I have a list of dates/values and what i want to do is look at these dates (Sunday-Thusday). If the date falls on a friday/sat/sun then ignore and move onto the next date(as these days dont have a value). Basically i am comparing week on week, but because a week has a friday etc within it, it skews the formula as week 1 should have prev week in it and week two current week.. I have attached an example of what i am trying to do.

Any help would be appreciated.

uulwyn

 

[Hui]

Uulwyn

I think this is what your after:


see formulas in the attached file:

 

[Pavan.Sada.PS]

Hello uulwyn,

Please chk the attached file and let me know if it suffice your problem

 

[uul]

Superb Pavan, thankyou ever so much for doing this. Appreciate your time in looking, sorry if my thread description wasnt clear about what the problem was before you looked at it.

 

[uul]

Thx Hui also - both worked brilliantly.