Format in a formula month and numbers

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

FAQ

Mark Forums Read

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: 553

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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 09:18 PM.