One way

In B1:
=IF(A1="","",IF(DAY(A1)=15,DATE(YEAR(A1),MONTH(A1 )+1,1),DATE(YEAR(A1),MONTH(A1),1)))
Format B1 as custom, type: mmm-yy. Copy down.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Angela" wrote:
If date in column A is less than 15th of month is there a formula I can use
to display the next mth in column B such that I can obtain the following

Column A Column B
05-Oct-07 Oct-07
05-Nov-07 Nov-07
15-Oct-07 Nov-07
19-Nov-07 Dec-07

Thanks
--
Angela