=NETWORKDAYS(TODAY()-DAY(TODAY())+1,TODAY())/NETWORKDAYS(TODAY()-DAY(TODAY()
)+1,DATE(YEAR(TODAY()),MONTH(TODAY())+1,0))

and format as percentage


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"johnm" wrote in message
...
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