Format in a formula month and numbers

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

02-27-2019, 09:36 PM

xor

Windows 10 Format in a formula month and numbers

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,100

With date in A1

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

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

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:24 PM.