Stupid Time Question

EdE · Apr 23rd, 2002, 12:55 PM

How do I get the beginning of the month with a date somewhere in the middle. I know it is a simple subtraction and plus function but I cant remember what it is.

Thanks

Mark W. · Apr 23rd, 2002, 01:00 PM

Use =DATE(YEAR(A1),MONTH(A1),1) where A1 contains your "middle of the month" date.

IML · Apr 23rd, 2002, 01:01 PM

with a date in A1, you could use
=+A1-DAY(A1)+1

EdE · Apr 23rd, 2002, 01:01 PM

Thanks. That was easier than the formula!!

Mark W. · Apr 23rd, 2002, 01:03 PM

Quote:

On 2002-04-23 12:01, EdE wrote:
Thanks. That was easier than the formula!!

Or, yet another way (with fewer operators)...

=TEXT(A1,"m/yyyy")+0

[ This Message was edited by: Mark W. on 2002-04-23 12:06 ]

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

Apr 23rd, 2002, 12:55 PM	#1
EdE Board Regular Join Date: Apr 2002 Location: A Mile High!! Posts: 230	How do I get the beginning of the month with a date somewhere in the middle. I know it is a simple subtraction and plus function but I cant remember what it is. Thanks

Apr 23rd, 2002, 01:00 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Use =DATE(YEAR(A1),MONTH(A1),1) where A1 contains your "middle of the month" date.

Apr 23rd, 2002, 01:01 PM	#3
IML MrExcel MVP Join Date: Feb 2002 Location: Denver, CO Posts: 1,744	with a date in A1, you could use =+A1-DAY(A1)+1