LinkBack URL
About LinkBacks
How can days be allocated into the periods in which they fall if they run across a number of months.
The attached sample might explain it better.
How can days be allocated into the periods in which they fall if they run across a number of months.
The attached sample might explain it better.
Last edited by BRISBANEBOB; 07-05-2009 at 07:31 PM.
Hello Bob, try putting this formula in F13 and copy across and down
=MAX(0,MIN(F$12,$E13)-MAX(F$12-DAY(F$12),$D13))
That works a treat, but can you expalin to me how it works?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks