Hi, i work out pro-rata revenue to target on a daily basis given the number of business days in a month. ie Feb has 28 days, and today (wed, 12th Feb) is day 8 in my pro-rata calculation. Is there formula that could update the business day count automatically everyday so i don't need to keep updating it manually? Is it NETWORKDAYS.INTL?!
Probably seems trivial, but it feeds into other formulas on other sheets and can throw things off if not updated manually etc... thanks!
If "A2" is 01-02-2020
In "B2" : =today()
In "C2" : =NETWORKDAYS(A2,B2)
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks