Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula date question?
I have two weeks of dates in a column, 6/5/06 through 6/11/06 a couple of empty cells and then continues from 6/12/06 trough 6/18/06. There is one date in each cell. So it looks something like this.... 6/5/06 6/6/06 6/7/06 6/8/06 6/9/06 6/10/06 6/11/06 6/12/06 6/13/06 6/14/06 6/15/06 6/16/06 6/17/06 6/18/06 Now I want to make a formula to to show (in two cells) like this.... first cell should show.... 6/5/06-6/11/06 Second cells should show.... 6/12/06-6/18/06. I want it to correspond to whatever is in the cells for that week. Thank you in advance for your help. -- uptwospeed ------------------------------------------------------------------------ uptwospeed's Profile: http://www.excelforum.com/member.php...fo&userid=3844 View this thread: http://www.excelforum.com/showthread...hreadid=549161 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula date question?
Assuming your data is in cells A1:A7 and A10:A16, first cell formula should be:
=TEXT(A1,"m/d/yy")&"-"&TEXT(A7,"m/d/yy") second cell formula should be: =TEXT(A10,"m/d/yy")&"-"&TEXT(A16,"m/d/yy") -Simon "uptwospeed" wrote: I have two weeks of dates in a column, 6/5/06 through 6/11/06 a couple of empty cells and then continues from 6/12/06 trough 6/18/06. There is one date in each cell. So it looks something like this.... 6/5/06 6/6/06 6/7/06 6/8/06 6/9/06 6/10/06 6/11/06 6/12/06 6/13/06 6/14/06 6/15/06 6/16/06 6/17/06 6/18/06 Now I want to make a formula to to show (in two cells) like this.... first cell should show.... 6/5/06-6/11/06 Second cells should show.... 6/12/06-6/18/06. I want it to correspond to whatever is in the cells for that week. Thank you in advance for your help. -- uptwospeed ------------------------------------------------------------------------ uptwospeed's Profile: http://www.excelforum.com/member.php...fo&userid=3844 View this thread: http://www.excelforum.com/showthread...hreadid=549161 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula date question?
So combining the two threads:
=TEXT(MIN(A1:A7),"m/d/yy")&"-"&TEXT(MAX(A1:A7),"m/d/yy") -- Reply by thread only thanks Allllen "SiC" wrote: Assuming your data is in cells A1:A7 and A10:A16, first cell formula should be: =TEXT(A1,"m/d/yy")&"-"&TEXT(A7,"m/d/yy") second cell formula should be: =TEXT(A10,"m/d/yy")&"-"&TEXT(A16,"m/d/yy") -Simon "uptwospeed" wrote: I have two weeks of dates in a column, 6/5/06 through 6/11/06 a couple of empty cells and then continues from 6/12/06 trough 6/18/06. There is one date in each cell. So it looks something like this.... 6/5/06 6/6/06 6/7/06 6/8/06 6/9/06 6/10/06 6/11/06 6/12/06 6/13/06 6/14/06 6/15/06 6/16/06 6/17/06 6/18/06 Now I want to make a formula to to show (in two cells) like this.... first cell should show.... 6/5/06-6/11/06 Second cells should show.... 6/12/06-6/18/06. I want it to correspond to whatever is in the cells for that week. Thank you in advance for your help. -- uptwospeed ------------------------------------------------------------------------ uptwospeed's Profile: http://www.excelforum.com/member.php...fo&userid=3844 View this thread: http://www.excelforum.com/showthread...hreadid=549161 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
date that updates itself daily, plus another formula please?? | Excel Worksheet Functions | |||
Formula date question | Excel Discussion (Misc queries) | |||
Value between 2 dates | Excel Worksheet Functions | |||
Date formula | Excel Worksheet Functions |