Thread: Date Diffrence
View Single Post
 
Old 11-20-2021, 03:47 PM
p45cal's Avatar
p45cal p45cal is online now Windows 10 Office 2019
Expert
 
Join Date: Apr 2014
Posts: 867
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

See msg#6.

As an aside, you have many formulae with SUM in, most of which are unnecessary:
=SUM(D3*$A$21)/100
can be:
=D3*$A$21/100

=SUM(D3*$A$22)/100*0.95
can be:
=D3*$A$22/100*0.95

=SUM(C3/K3)
becomes:
=C3/K3

=SUM(E3+F3)
can be either:
=E3+F3
or:
=SUM(E3,F3)
or:
=SUM(E3:F3)

=SUM((B3-B2)/L3)
goes to:
=(B3-B2)/L3
Reply With Quote