dates got me stuck

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Why not extract the day from the date using

A1: 4/3/2007
A2: =day(A1) results in 3
 
That did it I got it to work here is my formula

=IF(DAY(C20)<16,PRODUCT(D21*0.5),PRODUCT(D21*0.25))
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating Phone Bills Help Please 4
Excel Beginner-need help creating speeding fines system with butto 3
identifying data from a separate worksheet 1
How do I change this to count days 1
Points Ranking Formulas 22
Linking sheets which must update the date first. 3
Converting a date to a text field w/o converting it to a julian da 2
sumproduct & dates 3

Back
Top