|
|
|
|
#1
02-28-2019, 02:50 AM
|
|||
|
|||
Code:
=TEXT(Date,"yyyy-mm-") & RIGHT("000" & Obr,3)
|
|
#2
02-28-2019, 04:13 AM
|
||||
|
||||
|
Noted, Pecoflyer about the sample data. Thank you Xor and Arvi. I got confused by the "DAY" in both of your formula and when I removed it just leaving the "ObR" as the reference, the result is still the desired format, 2019-01-001. I need to explore further the function of the two negatives before the formula. I tried deleting the negatives but the formula returned 2019-1-1.
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need Help Deleting Numbers in Hour Format and Numbers in Sequence | rsrasc | Word VBA | 1 | 10-12-2016 02:49 PM |
 Formula For Displaying Exact Days of the Month
|
ddhawks | Excel | 2 | 07-12-2016 11:48 PM |
|
Formula to divide if no of days in month is 28
|
shilabrow | Excel | 5 | 06-26-2014 12:17 AM |
| Formula to count entries as per month, year and submission wise from different sheets | pinkacidpunk | Excel | 1 | 05-28-2013 08:26 AM |
| Formula to subtract one month from due date field in reminder field | ghumdinger | Outlook | 1 | 10-01-2011 12:09 AM |
Windows 8 
Office 2016
Hybrid Mode