Date formulas

  • Thread starter Thread starter Construk
  • Start date Start date
C

Construk

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
 
In A2:

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

Copy down as far as needed
 
In A2: =IF(A1="","",IF(A1+1<EDATE($A$1,1),A1+1,""))

copy down as far as needed
 
You must log in or register to reply here.

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

Another date formula 4
conditional formatting of dates 3
credit intrest on intrest 1
Need a formula 1
Date formula 4
Finding available payment date 5
date function 10
Date formula rounded up 2

Back
Top