formula to indicate date range on a calendar

I have attached a file which indicates what I am trying to achieve.
The first question is can this be done and then who do I set it up

Any assistance appreciated

Barry

Hello Barry,

Please change your thread title as per forum rules, specifically rule 1 which says that "Your post title should accurately and concisely describe your problem".

It's concise, I'll give you that, but I would assume that virtually any post in the "Excel worksheet functions" forum could be labelled "worksheet formula". Please be more specific, thanks.

Thanks
Not sure how to change the title
Can you assist please

Am still trying to find out how I edit the title of this thread

Apologies, Barry, I wasn't deliberately ignoring you. It was late here when you posted back so I was off to my bed....also I should have linked to the rules [thanks protonLeah]

I changed the thread title for you....

Note you might want to post that file as a version other than Excel 2007, otherwise users without that version won't be able to open it.....

Given your example you could get an X in the cells you want by using this formula in B6 copied across and down

=IF(AND($B$2+B$4-1>=$F18,$B$2+B$4-1<=$O18),"X","")

Note: I assumed that the tasks in A6:A13 would be listed in the same order as A18:A25, although you could modify the formula if that isn't so.....

Your are brilliant however when I pasted the formula into one cell it wanted to occupy 2
See attached
Thanks for your assistance

Many thanks.
And huge alteration to the formular if it spans a number of months.
The Sheet I am working on has 6 months one after the other

Appreciat your assistance

Many thanks again I have figured out the rest for the moment.
But while I am on a roll can the formula be adjusted to eliminate the X on the Saturday and the Sunday.
I tend to shade these days in Grey.

Your help in solving this problem is much appreciated

Barry

On your example the days of the week in B3:AF3 don't correctly match the dates. You could automate this with this formula in B3 copied across

=LEFT(TEXT($B2+B4-1,"ddd"))

and then the formula for B6, adjusted to exclude weekends, would be

=IF(AND($B$2+B$4-1>=$F18,$B$2+B$4-1<=$O18,B$3<>"S"),"X","")

Note: If you're only placing an "X" in the relevant cells in order that they get shaded then you could do that directly through conditional formatting without the need for formulas on the worksheet.

Appreciate the help
Thanks

Barry