Monthly Weekly Daily Target Turnover

koamei

New Member
Joined
Oct 14, 2019
Messages
1
Hi,

I have the yearly turnover target for a company and would like to calculate the monthly, weekly and daily targets to meet the yearly. I want to be able to put the actual daily revenue and automatically recalculate the next day target and the next month target. For example if my yearly target is $50,000 the company needs to make $136.98 daily if one day the company makes 0 then the next day target should be recalculated to show $273.97.

Can someone please help me and give me some guidelines on how to make the above?

Thanks in advance!
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Watch MrExcel Video

Forum statistics

Threads
1,095,783
Messages
5,446,474
Members
405,403
Latest member
horace james

This Week's Hot Topics

Top