Format in a formula month and numbers

		Microsoft Office Forums > Microsoft Excel > Excel
Format in a formula month and numbers

FAQ

Thread Tools

Display Modes

02-27-2019, 11:31 PM

Marcia

Windows 7 32bit Format in a formula month and numbers

Office 2007

Expert

Join Date: May 2018

Location: Philippines

Posts: 551

Quote:

Originally Posted by xor

With date in A1

=DATE(YEAR(A1),MONTH(A1),DAY(A1))

Format the cell with the formula: yyyy-mm-"00"d

Thank you Xor for the immediate reply. The formula should return the year and month from A1, after the month is a serial number taken from B1, like:

A1: January 18, 2019 (named range "Date")

B1: 1 (named range "ObR")

C1 where the formula is: 2019-01-001

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:06 PM.