From date to date

%3CLINGO-SUB%20id%3D%22lingo-sub-2226592%22%20slang%3D%22en-US%22%3EFrom%20date%20to%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2226592%22%20slang%3D%22en-US%22%3E%3CP%3Ehow%20can%20I%20enter%20a%26nbsp%3BFrom%20date%20to%20a%20date%20in%20one%20cell%20in%20excel%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2226592%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2226616%22%20slang%3D%22en-US%22%3ERe%3A%20From%20date%20to%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2226616%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1004230%22%20target%3D%22_blank%22%3E%40ZalmenG%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELet's%20say%20the%20start%20date%20is%20in%20A2%20and%20the%20end%20date%20in%20B2.%3C%2FP%3E%0A%3CP%3EThe%20formula%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DTEXT(A2%2C%22mmmm%20d%22)%26amp%3B%22%20-%20%22%26amp%3BTEXT(B2%2C%22mmmm%20d%22)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ewill%20return%20the%20date%20range%20looking%20like%20this%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFebruary%2028%20-%20March%2010%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20use%20another%20date%20format%20of%20course%2C%20and%20change%20the%20way%20the%20range%20is%20presented.%20For%20example%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3D%22From%20%22%26amp%3BTEXT(A2%2C%22m%2Fd%2Fyyyy%22)%26amp%3B%22%20to%20%22%26amp%3BTEXT(B2%2C%22m%2Fd%2Fyyyy%22)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ewill%20return%20the%20date%20range%20looking%20like%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFrom%202%2F28%2F2021%20to%203%2F10%2F2021%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

how can I enter a From date to a date in one cell in excel?

1 Reply

@ZalmenG 

Let's say the start date is in A2 and the end date in B2.

The formula

 

=TEXT(A2,"mmmm d")&" - "&TEXT(B2,"mmmm d")

 

will return the date range looking like this:

 

February 28 - March 10

 

You can use another date format of course, and change the way the range is presented. For example

 

="From "&TEXT(A2,"m/d/yyyy")&" to "&TEXT(B2,"m/d/yyyy")

 

will return the date range looking like

 

From 2/28/2021 to 3/10/2021