Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Exclude Weekends
HI i have a chart linked to source data (10 days history with a number beside each day) . I entered a worksheet formula to automatically show previous 10 working days - see below. Problem is the graph seems to recognise these are dates and shows in the graph the weekend days even though these days are not in the source data any ideas? =IF(WEEKDAY(A7)=2,A7-3,A7-1) -- Kevin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting to Exclude Weekends | Excel Worksheet Functions | |||
How do I set up a calculation to exclude weekends? | Excel Worksheet Functions | |||
Date Calculation to exclude weekends | Excel Worksheet Functions | |||
calculation to exclude weekends | Excel Worksheet Functions | |||
Schedule to exclude weekends and holidays | Excel Discussion (Misc queries) |