Divide Monthly Sales Budget to Day Budget
 

Hi



The sales budget in my company for the year 2006 is done on month level. Is
there some way for me to divide the budget to day level?



best regards

Benedikt F

Computer department

Iceland Seafood Int

Divide Monthly Sales Budget to Day Budget
 

(365.25 days in a year on average)/(12 months in a year)=30.4375 days in a
month on average.

So....

Daily Budget = Monthly Budget / 30.4375


Does that help?
--
Regards,
Dave


"Benedikt Fridbjornsson" wrote:

Hi



The sales budget in my company for the year 2006 is done on month level. Is
there some way for me to divide the budget to day level?



best regards

Benedikt F

Computer department

Iceland Seafood Int

Divide Monthly Sales Budget to Day Budget
 

Hi

Just divide the monthly figures by the number of days in each month.
If you have column headings of Jan Feb Mar etc. then rather than
entering those as text, enter as 01/01/2006 through to 01/12/2006 but
format the cells FormatCellsNumberCustom mmm
Assuming that January is in column B, then the number of days in each
month becomes
=DAY(DATE(YEAR(B$1),MONTH(B$1)+1,0))
Copy across for succeeding months.
Your daily Budget figure becomes
=Budget value for month/DAY(DATE(YEAR(B$1),MONTH(B$1)+1,0))
--
Regards

Roger Govier


"Benedikt Fridbjornsson" wrote in message
...
Hi



The sales budget in my company for the year 2006 is done on month
level. Is there some way for me to divide the budget to day level?



best regards

Benedikt F

Computer department

Iceland Seafood Int