dates got me stuck
 

I am trying to set up a worksheet to calculate a storage cost according to
date recieved. Ex. 200 cases recieved before the 16th charged at $0.50 per
case. Recieved o or after the 16th charged at $0.25 per case. I can get it to
work with just numbers but not with a full date. Any help would be
appreciated.

dates got me stuck
 

Why not extract the day from the date using

A1: 4/3/2007
A2: =day(A1) results in 3

"Suzuki Steve" wrote:

I am trying to set up a worksheet to calculate a storage cost according to
date recieved. Ex. 200 cases recieved before the 16th charged at $0.50 per
case. Recieved o or after the 16th charged at $0.25 per case. I can get it to
work with just numbers but not with a full date. Any help would be
appreciated.

dates got me stuck
 

That did it I got it to work here is my formula

=IF(DAY(C20)<16,PRODUCT(D21*0.5),PRODUCT(D21*0.25) )
--
Suzuki Steve


"Barb Reinhardt" wrote:

Why not extract the day from the date using

A1: 4/3/2007
A2: =day(A1) results in 3

"Suzuki Steve" wrote:

I am trying to set up a worksheet to calculate a storage cost according to
date recieved. Ex. 200 cases recieved before the 16th charged at $0.50 per
case. Recieved o or after the 16th charged at $0.25 per case. I can get it to
work with just numbers but not with a full date. Any help would be
appreciated.

dates got me stuck
 

Shorter Version

=IF(DAY(C20)<16,0.5,0.25)*D21


"Suzuki Steve" wrote:

That did it I got it to work here is my formula

=IF(DAY(C20)<16,PRODUCT(D21*0.5),PRODUCT(D21*0.25) )
--
Suzuki Steve


"Barb Reinhardt" wrote:

Why not extract the day from the date using

A1: 4/3/2007
A2: =day(A1) results in 3

"Suzuki Steve" wrote:

I am trying to set up a worksheet to calculate a storage cost according to
date recieved. Ex. 200 cases recieved before the 16th charged at $0.50 per
case. Recieved o or after the 16th charged at $0.25 per case. I can get it to
work with just numbers but not with a full date. Any help would be
appreciated.