Changing Weekly timescaled data to show different date

J

JPD

Our company works on a work week Sat-Friday. I do exports to excel
that will show timescaled data, but it will show that Sundays date as
the date for the start of that week.

For Example this week it would show the data labeled 6/10/07. Ideally
i would like my work week data to be Saturday-Friday and display this
weeks data as 6/15/07. Is this possible ???

Thanks,
J
 
D

DavidC

Hi,

Try setting the start of the work week under "Tools/Options/Calendar" and
change the drop down box "Week starts on.." to 'Saturday'

Hope this helps

Regards

DavidC
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help to Highlight Excel Row based on Weekly Date Range 2
changing settings to non-standard work week 6
Conditional format or chart to show trend week by week 0
How to set the week to 6 days and not 5 3
Weekly or Bi-weekly dates 4
Weekly or Bi-Weekly dates 3
Recurring tasks occur during non-working times 0
Detemine sales order based on plac changes and not sales figures -mathmatic problem to solve 1

Top