Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula needed for date range
A5 is 1st Date
A90 is 2nd Date (2nd date is always 14 days later than A5 Date) Text and Format wanted is Dates: 04/11/05 - 04/25/05 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula needed for date range
Here is a formula that will give you the text of what you asked for.
=TEXT(A5, "mm/dd/yy") &" - " & TEXT(A5+14, "mm/dd/yy") Note that this formula returns a text string not a date that Excel can interpret...without a little bit of work... HTH "klt" wrote: A5 is 1st Date A90 is 2nd Date (2nd date is always 14 days later than A5 Date) Text and Format wanted is Dates: 04/11/05 - 04/25/05 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula needed for date range
One way:
=TEXT(A5,"mm/dd/yy - ") & TEXT(A5+14,"mm/dd/yy") In article , klt wrote: A5 is 1st Date A90 is 2nd Date (2nd date is always 14 days later than A5 Date) Text and Format wanted is Dates: 04/11/05 - 04/25/05 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula needed for date range
Thank you Jim. I've been working on this forever. I'm not very good with
formulas. I really appreciate your response. klt "Jim Thomlinson" wrote: Here is a formula that will give you the text of what you asked for. =TEXT(A5, "mm/dd/yy") &" - " & TEXT(A5+14, "mm/dd/yy") Note that this formula returns a text string not a date that Excel can interpret...without a little bit of work... HTH "klt" wrote: A5 is 1st Date A90 is 2nd Date (2nd date is always 14 days later than A5 Date) Text and Format wanted is Dates: 04/11/05 - 04/25/05 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula needed for date range
=TEXT(A5,"mm/dd/.yy")&" - "&TEXT(A90,"mm/dd/yy")
-- HTH RP (remove nothere from the email address if mailing direct) "klt" wrote in message ... A5 is 1st Date A90 is 2nd Date (2nd date is always 14 days later than A5 Date) Text and Format wanted is Dates: 04/11/05 - 04/25/05 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula needed for date range
Thank you JE.
"JE McGimpsey" wrote: One way: =TEXT(A5,"mm/dd/yy - ") & TEXT(A5+14,"mm/dd/yy") In article , klt wrote: A5 is 1st Date A90 is 2nd Date (2nd date is always 14 days later than A5 Date) Text and Format wanted is Dates: 04/11/05 - 04/25/05 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date formula needed | Excel Worksheet Functions | |||
Date Formula with 2 conditions met needed | Excel Discussion (Misc queries) | |||
Date Conversion Formula Needed | Excel Worksheet Functions | |||
Date formula needed | Excel Worksheet Functions | |||
Date formula needed | Excel Discussion (Misc queries) |