dates got me stuck

S

Suzuki Steve

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.
 
B

Barb Reinhardt

Why not extract the day from the date using

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

Suzuki Steve

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

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

Teethless mama

Shorter Version

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


Suzuki Steve said:
That did it I got it to work here is my formula

=IF(DAY(C20)<16,PRODUCT(D21*0.5),PRODUCT(D21*0.25))
Click to expand...
 
Top