excel & series

Hello, I am looking for a formula to show "Wk 1" for seven consecutive dates and than show "Wk 2" and so on till the end of the year date. The example is shown below. In this case the fiscal year starts from Feb 01 of current year and end Jan 31 of the following year, this is a retail calendar...

Hi there, My example is that on column A, I have different names. Let these be, in order of appearance, starting with <code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono"...

Hi, I have below table1 (sheet1): <tbody> <tbody> StartDate(A1) </tbody> <tbody> EndDate(B1) </tbody> Month(C1) Quater(D1) Year(E1) <tbody> 29/07/2012 </tbody> <tbody> 25/08/2012 </tbody> 1 Q1 <tbody> 2013 </tbody> <tbody> 26/08/2012 </tbody> <tbody> 22/09/2012...

how to plot time series data in excel? i have some data set like this : day between two dates are not fixed, sometimes 2 days, sometimes 3 days, .. 5 data are collected on certain day: 29/03/2013...26/03/2013 ...and so on.. thanks in advance for any help!!:confused::) <tbody>...

Hello- I would like to have a cell that would automatically display the next occurrence of a bi-weekly occurring meeting. For instance if the first meeting is 4/4 and I pull the report up today it will say the next meeting is 4/4. But if I look at the report on 4/5 it will say the next...

I have several series of data in stacked column chart and I am trying to achieve that plot order will be dynamic due to some values, but in =SERIES plot order must be integer and I can´t find other way to do that. Do you have any idea or advice? Thanks for help.