LinkBack URL
About LinkBacks
If you put the 1st of each month in C2 across then you can use this formula in C3 copied across and down
=MAX(0,MIN(EOMONTH(C$2,0),$B3-1)+1-MAX(C$2,$A3))
see attached
If you put the 1st of each month in C2 across then you can use this formula in C3 copied across and down
=MAX(0,MIN(EOMONTH(C$2,0),$B3-1)+1-MAX(C$2,$A3))
see attached
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks