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
|