LinkBack URL
About LinkBacks
In c2
=MAX(0,MIN(DATE(C$1,12,31),$B2)-MAX(DATE(C$1,1,1),$A2)+1)
Copy down and across
In c2
=MAX(0,MIN(DATE(C$1,12,31),$B2)-MAX(DATE(C$1,1,1),$A2)+1)
Copy down and across
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks