|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 5th, 2010, 10:27 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 
|
|
#2
January 5th, 2010, 10:45 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
|
#3
January 5th, 2010, 11:26 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date formulas
In A2: =IF(A1="","",IF(A1+1EDATE($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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
