Dynamically calculate days that have passed in a month
This may be a basic question for some of you, but here goes... I need to calculate average activity by day but change the number dynamically as days pass within a month. Cell a1 has a monthly cumulative activity value, cell b1 would have the formula to calculate the daily average activity.
Well, since a month starts on day 1 and increments, couldn't you simply divide the A1 value by today's DAY value?
=A1/DAY(TODAY())
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks, but to put a wrinkle in that formula, today I have to calculate on yesterdays activity. Can I do today-1?
Thanks for getting me in the right direction so quickly. I figured it out!
Good job. I have marked this thread solved for you.
In the future please select Thread Tools from the menu above and mark the thread as solved. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks