| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hmm Still stuck | Excel Discussion (Misc queries) | |||
| Help, please, I'm stuck | Excel Discussion (Misc queries) | |||
| Stuck... | Excel Discussion (Misc queries) | |||
| Please help, I'm stuck | Excel Discussion (Misc queries) | |||
| Stuck with an =IF | Excel Worksheet Functions | |||
Linear Mode
