need help with formula

[dwatso]

i need to find the saving between $ based start date -

I have =sum(a1 divided by 2080) X days 360 (d1, g1) but it is not coming out right...

Can someone help.

 

[Michael M]

You question is a little unclear, but do you mean
D1 is the start date and G1 is the end date ?
If so, try

=SUM(A1/2080)*(G1-D1)

 

[dwatso]

Thanks! Yes, that is what I mean but in addition to your suggestion I need to include the days 360 formula

so...

for istance
a1=actual salary
d1=proposed start date
f1=actual start date

=sum (a1/2080)*days360 (d1,f1)

I need to figure out the total savings of actual salary based on actual strt date

Does this make sense?
or do you need more info??

Thanks!

 

[Scott R]

Thanks! Yes, that is what I mean but in addition to your suggestion I need to include the days 360 formula

so...

for istance
a1=actual salary
d1=proposed start date
f1=actual start date

=sum (a1/2080)*days360 (d1,f1)

I need to figure out the total savings of actual salary based on actual strt date

Does this make sense?
or do you need more info??

Thanks!

Looks like you're taking hourly rate times # of days (rather than hours).
How about =A1/2080*Days360(d1,f1)*8

 

[dwatso]

that worked, thanks!