Time-Series Chart that skips weekend dates along the X axis... can it be done?
Posted on 2011-05-02
I use this formula (below) in a column to create workday dates that skip Sat & Sun. However, the time-series chart linked to these dates display continuous dates including the Saturdays and Sundays. Question: Is there a way to coax Excel into skipping the Saturday & Sunday dates on the chart to suppress (skip) weekends? Or is Excel's X-axis hard wired with regard to dates with time-series charts.
=IF(OR(WEEKDAY(A2+1)=1,WEEKDAY(A2+1)=7),A2+3,A2+1)... where A2 contains a date