MTD Budget Numbers /

[kjwaller]

My month to date budget number is a calculation of DAILY BUDGET X Days COMPLETED in the month. ( January has 22 working days)

Daily budget = 60,000 (Static Number derived from a separate calculation)
X Days Completed (5)
____________________

MTD Budget of 300,000


Tomorrow the formula would say

Daily budget = 60,000
X Days Completed (6)
____________________

MTD Budget of 360,000


Everyday I need to caluclate this number. Question is how do I do this without rewriting the formula everyday to calculate the days completed in the month?

 

[Special-K99]

Maybe

NETWORKDAYS(startdate,TODAY())

 

[barry houdini]

Which days are you counting, wouldn't it be 6 today?

You can get working days so far this month (up to yesterday) with this formula

=NETWORKDAYS(EOMONTH(TODAY()-1,-1)+1,TODAY()-1,H$2:H$10)

where H2:H10 contains holiday dates

On the 1st of the month that will still show last months total days

 

[kjwaller]

Fantastic - Yes, today would be #6 - i mistyped. Let me try this bad boy out.