View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JohnM JohnM is offline
external usenet poster
 
Posts: 27
Default how do i automatically update % figures daily

I have a sales figure sheet showing month to date etc ..on this sheet I also
show the % of month gone .. so Sept's got 26 trading days @ 3.85% per day
... how can I get this figure to automatically update each day ( at the moment
I have to do manually) .. . so that day 2 = 7.7% ... day 3 = 11.55% ...
until last day 100%

Many thanks
John