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
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
(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
>
>
>
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 Format>Cells>Number>Custom 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" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks