Change formula in chart

[jazzkid]

Hi

I have a Gantt Chart from Chandoo projects which has the dates noted as workdays only. I need all days, Monday to Sunday to be shown and cannot determine the formula to alter the formula in row 2 from F3 to alter to include every day of the week. Can anyone assist please. I tried altering this to "=WEEKDAY(F2,1)" from "=WORKDAY(F2,1)" but this did not give the appropriate dates. I'm sure this is very basic and easy - just can't get what I require. Thank you for any assistance.

 

[Chihiro]

Change formula to...
=F2+1

 

[jazzkid]

Thanks Chihiro. That partly worked, however, the month row now shows Jan and then Feb and should be Oct and then Nov. Other thoughts?

 

[Chihiro]

As long as you didn't change F2. You should have correct dates.

F2 should have =prjStDate which is named range that refers to.
=Inputs!$C$2

Which contains 1-Oct-16 in the workbook you uploaded.

The formula just adds 1 day as you copy over formula from Column G across.

 

[jazzkid]

Not sure what happened. I only altered G2 and a few subsequent cells. See attached. I just extended the days to S2 and realised this formula changes the dates to the days of the week not days of the month? The months are still showing Jan not Oct. Please see attached - again any ideas of what is incorrect with the formula.

 

[Chihiro]

Here. See attached. You had wrong formula for G2 onward.

 

[jazzkid]

Thanks Chihiro. Knew it was simple - was making it harder than it should be Much appreciated.