Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXCEL - formula for linking dates and prices
Hy,
How can I make formula which can link my table with different seasons and different price types for each season? For example: I have price from 12th May - 20th May = 15,00 eur, from 20th May-30th May= 20,00 eur. What is my goal? If I have different clients that use different service in different period: client A: use service from 12th-25th May (it means: 15,00eur x 8 days = 120,00 eur + 20,00eur x 5 days = 100,00 eur) client B: use service from 15th-22th May (15,00eur x 3days = 45,00 eur + 20,00 eur x 2days = 40,00 eur). MY QUESTION: How can I link different dates with particular price list? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates and linking between spreadsheets question. | Excel Discussion (Misc queries) | |||
Linking dates and values | Excel Discussion (Misc queries) | |||
Linking cells that contain dates | Setting up and Configuration of Excel | |||
Use a multiplier to change List Prices to Net prices | Excel Worksheet Functions | |||
Linking dates with a calendar... | Excel Worksheet Functions |