| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I get the address of a cell to calculate with it
I am seraching for a formula to compare the prices of hotels putting the
dates of beginning and end of my holidays in two Excel cells. The Hotels have different price during the summer like: Jun-20/Jul-25 Jul-25/Aug-1 Aug-1/Aug-31 Aug-31/sep-30 Hotel A $ 50 $ 90 $ 150 $ 40 Jun-20/Jul-20 Jul-20/Aug-10 Aug-10/Aug-20 Aug-20/sep-15 Hotel B $ 45 $ 99 $ 140 $ 60 What are the costs from i.e. Jun-25 until Aug-10? Thank you for who wil help me. -- dilettante |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Address of Maximum value in Cell | Excel Worksheet Functions | |||
| Cell Address Matching | Excel Worksheet Functions | |||
| Replace a spreadsheets named cells/ranges with exact cell address. | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| How do I find the contents of a cell using the "ADDRESS" function. | Excel Worksheet Functions | |||
Threaded Mode
