?
Solved

Dat formatting in a formula

Posted on 2016-09-27
2
Medium Priority
?
40 Views
Last Modified: 2016-09-27
Experts, how would I format the 'Date Entry'!D23  to date format?  

="for the period between " &'Date Entry'!D23 & "and " &'Date Entry'!E23

the output is like so:
for the period between 42542and 42724


thank you
0
Comment
Question by:pdvsa
2 Comments
 
LVL 7

Accepted Solution

by:
D Patel earned 2000 total points
ID: 41817702
Try This :

="for the period between " & TEXT('Date Entry'!D23, "dd/mm/yyyy") & " and " & TEXT('Date Entry'!E23, "dd/mm/yyyy")
0
 

Author Closing Comment

by:pdvsa
ID: 41817840
perfect.  thank you
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
With the functions here, you can parse, convert, and format back and forth between feet and inches and fractions and decimal inches - for normal as well as extreme values and with extreme precision.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question