Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Text
Hello,
This formula: =TEXT(B282,"mmm d")& " - " &TEXT(B306,"mmm d") To produce the following: Jan 2 - Jan 6 What I would like to do is have the result show this: Week of Jan 2 - Jan 6 Thanks for the help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Text
In addition,
I need to know how to write the formula to show the start date (-1) minus 1 day and the end date (+1) plus one day. Thanks "Jim" wrote: Hello, This formula: =TEXT(B282,"mmm d")& " - " &TEXT(B306,"mmm d") To produce the following: Jan 2 - Jan 6 What I would like to do is have the result show this: Week of Jan 2 - Jan 6 Thanks for the help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Text
Try: ="Week of " & TEXT(B282,"mmm d")& " - " &TEXT(B306,"mmm d")
-- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Jim" wrote in message ... Hello, This formula: =TEXT(B282,"mmm d")& " - " &TEXT(B306,"mmm d") To produce the following: Jan 2 - Jan 6 What I would like to do is have the result show this: Week of Jan 2 - Jan 6 Thanks for the help. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Text
Try:
="Week of "&TEXT(B282-1,"mmm d")& " - " &TEXT(B306+1,"mmm d") -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Jim" wrote in message ... In addition, I need to know how to write the formula to show the start date (-1) minus 1 day and the end date (+1) plus one day. Thanks "Jim" wrote: Hello, This formula: =TEXT(B282,"mmm d")& " - " &TEXT(B306,"mmm d") To produce the following: Jan 2 - Jan 6 What I would like to do is have the result show this: Week of Jan 2 - Jan 6 Thanks for the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I convert a text string into a date? | Excel Worksheet Functions | |||
Converting number or text to a Date Format | New Users to Excel | |||
Macro to convert text to date | Excel Worksheet Functions | |||
Change Text Data to Date | Excel Discussion (Misc queries) | |||
EXTRACT TEXT FROM A DATE | Excel Worksheet Functions |