This may give you what you need. 8 columns A - H headings as follows

month today days in month month target daily
target
Month start date =TODAY() =B2-A2 800 =D2/30


target to date current workstate Progress percent
=E2*C2 400 =G2/F2%

It's not very sophisticated but will do the job. I'm assuming a 30 day
month but you can change that in the daily target calc. Post back if it
doesn't make sense.
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"DZ" wrote:

I have a monthly budget figure, and I'm trying to use a formula to show what
% of budget I'm at on a daily basis. For instance, my budget for the month is
that I'll make 800 items, and halfway through the month if my actuals show
I've made 400 items, I want the % of budget column to show 100%, not 50%.
How do I do this? Thanks in advance for your help.