sum a value between two date

[gjonm]

Hi all!

I'm trying find a formula to multiply a number by the number of days between two dates.

For example:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Number
[/TD]
[TD]From Date
[/TD]
[TD]To Date
[/TD]
[TD]SUM
[/TD]
[/TR]
[TR]
[TD]2.21
[/TD]
[TD]01/01/2018
[/TD]
[TD]28/02/2018
[/TD]
[TD][result]
[/TD]
[/TR]
</tbody>[/TABLE]

So I'm looking for a formula to provide a result summing 2.21 x 28.

I hope this makes sense!

Thanks, gjonm

 

[Joe4]

Welcome to the Boad!

So I'm looking for a formula to provide a result summing 2.21 x 28.

Why 28?
Aren't there 59 days between January 1 (From Date) and February 28 (To Date)?

Note that Excel store dates as numbers, specifically the number of days since 1/0/1900. So, to get the number of days between two dates, simply subtract the smaller from the larger, i.e.

=(C2-B2+1)*A2

 

[gjonm]

Simple then And yes you spotted my date range error too. Thanks Joe4!

 

[Joe4]

You are welcome!