Date formulas
 

Hi,
I'm doing a timesheet. The month begin on the 21 and end on 20th of each
month (don't ask). It'easy to set a listmenu to choose the month, have the
first day to start with the 21, having 31 line with =1+precedente line.

But for the three last line, idon't know how to have it to stop displaying
dates after the 20th, for Febuary and the other 30 days months.

An idea anyone?
thank

Date formulas
 

In A2:

=IF(A1="","",IF(MONTH(A1+1)=MONTH(A1),A1+1,""))

Copy down as far as needed

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Construk" wrote in message
...
Hi,
I'm doing a timesheet. The month begin on the 21 and end on 20th of each
month (don't ask). It'easy to set a listmenu to choose the month, have the
first day to start with the 21, having 31 line with =1+precedente line.

But for the three last line, idon't know how to have it to stop displaying
dates after the 20th, for Febuary and the other 30 days months.

An idea anyone?
thank

Date formulas
 

In A2: =IF(A1="","",IF(A1+1<EDATE($A$1,1),A1+1,""))

copy down as far as needed



"Construk" wrote:

Hi,
I'm doing a timesheet. The month begin on the 21 and end on 20th of each
month (don't ask). It'easy to set a listmenu to choose the month, have the
first day to start with the 21, having 31 line with =1+precedente line.

But for the three last line, idon't know how to have it to stop displaying
dates after the 20th, for Febuary and the other 30 days months.

An idea anyone?
thank