If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
HELP - Date Range In 1 Cell Calculation
Hello,
I have one cell where i enter a date 8/30/2005 (which resides in A3). And i need another cell to display a date range based on the above date. The date range will always be the same number of days apart. For example the date range will always be 2-7 days from the entered above date. What i did so far was 2 seperate calculations in 2 different cells. One for the low end (=SUM(A3+2) and one for the high end =SUM(A3+7). Then I put =(B3) & " " & "through" & " " & (C3) in the third cell where i want the range to appear. But what happens is it comes out like: 38596 through 38599 How can i get the dates to remain in date format even though there is text between them??? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copy Cat Ain't Working | shep | Setting Up & Running Reports | 15 | September 12th, 2005 05:14 PM |
Help PLEASE! Not sure what answer is: Match? Index? Other? | baz | Worksheet Functions | 7 | September 3rd, 2005 03:47 PM |
Possible Lookup Table | Karen | Worksheet Functions | 5 | June 8th, 2005 09:43 PM |
Query for 'confirmation' | rogge | Running & Setting Up Queries | 8 | April 19th, 2005 03:26 PM |
Formula help | Wally | Worksheet Functions | 6 | December 5th, 2003 12:18 PM |