LinkBack URL
About LinkBacks
If the range will always span the 3 periods in the table, then try this:-
=DAYS360(C2,"31/12/"&YEAR(C2))*C6/360+C7+DAYS360("1/1/"&YEAR(C3),C3)*C8/360
If the range will always span the 3 periods in the table, then try this:-
=DAYS360(C2,"31/12/"&YEAR(C2))*C6/360+C7+DAYS360("1/1/"&YEAR(C3),C3)*C8/360
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks