Need output result for input
Hi Experts,
Need output result for input:-
Please consider input as below:--
COMPRESS(NULL,'2008-06-30','2009-07-03'),
COMPRESS('2014-04-30'),
COMPRESS('P465','P4760'),
COMPRESS('','0','3'),
Expecting output as below(i.e only need to add 'DATE' keyword before date type data('yyyy-mm-dd') and rest all formats it should skip as below) :--
COMPRESS(NULL,DATE'2008-06-30',DATE'2009-07-03'),
COMPRESS(DATE'2014-04-30'),
COMPRESS('P465','P4760'),
COMPRESS('','0','3'),
Thanks in Advance Experts.......
Please attach an Excel sheet, and explain if these are all in one cell or multiple cells.
Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!
Click on GO ADVANCED and use the paperclip icon to open the upload window.
The paperclip icon
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
How to install your new code
- Copy the Excel VBA code
- Select the workbook in which you want to store the Excel VBA code
- Press Alt+F11 to open the Visual Basic Editor
- Choose Insert > Module
- Edit > Paste the macro into the module that appeared
- Close the VBEditor
- Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
Please Login or Register to view this content.
In B1 Cell
=AddDate(A1)
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Re: Need output result for input
Hi Glenn ,
Thanks for your quick response...
Attached the excel sheet . All the values are in different cells ,exactly what appear in attachment.
Please let me know if any further information needed.
Thanks,
Satyendra
What is the Maximum possible number of days in a single Cell
for example "A5" has "COMPRESS(NULL,'2008-06-30','2009-07-03')," here is 2 dates, what is the maximum possible number
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Maximum possible number is 255
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks