David, thank you very much..........

Greg
"David McRitchie" wrote in message
...
Hi Greg,
In that case what I provided is not what you want. You'd want something
like this and you can extend it down as far as you want and start with
any date (any day of any month of any year).

B2: (seed date) -- fill down from B3
B3: =IF(ISNUMBER(B2), IF(MONTH(B2)=MONTH(B2+1), B2+1,""),B1+1)
B4: =IF(ISNUMBER(B3), IF(MONTH(B3)=MONTH(B3+1), B3+1,""),B2+1)
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"GregR" wrote...
David it is for a timesheet. There are only 30 days in Nov, so if
B2=nov16,
I want the cell that would be the 31st blank or if b2="", I want the
rows to
display a generic timesheet 1/16, 2/17......................31. TIA

"GregR" wrote in message...
I am trying to populate a timesheet with dates depending on the start
date
in B2. If B2 is the 16th of the month of Sept, I don't want anything
to
show
up on the calendar for the 31th (blank in other words). Here is the
formula
I am using, but not working. Help. TIA

=IF(($B$2)="","31",IF(EOMONTH(B2,0)=TEXT(($B$2)+RO W()-14,"DDD
dd"),"",TEXT(($B$2)+ROW()-14,"DDD dd")))

Greg