Justlearnin:

Assuming cell A1 is your input date, place this formula in cell A2.

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

Place this formula in cell A3.

=DATE(YEAR(A1),MONTH(A1)+1,1)-1


Matt


--
Flintstone
------------------------------------------------------------------------
Flintstone's Profile: http://www.excelforum.com/member.php...o&userid=15310
View this thread: http://www.excelforum.com/showthread...hreadid=565804