Excel Help

[euro_scene]

down the left hand side I have a list of some tasks I have completed

and at the top I need the dates from the beginning of sept to the current date.. but I only want the dates on the days of Monday and Thurs

is there a quick way of doing that?

thanks

 

[euro_scene]

No

I want

Mon 7th Thurs 10th Mon 14th Thurs 17th


etc

 

[euro_scene]

Check my post, it explains exactly that.

yh thanks

I put this in B1 07/09/2009

then in C1 I put =IF(WEEKDAY(B1)=2,B1+3,B1+4)

nothing happend

 

[euro_scene]

pscreen?