date series

M

macropod

Hi jry,

If your first date is in A1, put the following formula in
A2 and copy down (or B1 and copy right):
=IF(DAY(A1)>15,DATE(YEAR(A1),MONTH(A1)+1,15),MIN(DATE(YEAR
(A1),MONTH(A1)+1,0),DATE(YEAR(A1),MONTH(A1),30)))

Cheers
PS: Remove NO.SPAM from the above before replying.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calendar Logic: Recurring Dates 3
date mismatching 2
Show value from one cell in another cell if today falls between a date range 5
Conditional Formatting - Given dates within certain range of days 4
Blanking cells with formulas 2
problem with time subtraction 7
YTD SUMIF based on current date 3
formula to subtract 60 days from a date (05/25/2010) 2003excel 3

Top