Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date formula
Morning,
I need to build a spreadsheet that will have the date in a column, running from the 15th of one month to the 15th of the next month i.e. 07-01-15 to 07-02-15. I would like the date to be entered onto a Parameters sheet and that needs to flow to the spreadsheet. The problem is that the spreadsheet needs to be duplicated depending on the number of drivers I have on the parameters list. I have a macro to add a spreadsheet depending on the number of drivers. I can simply then just add to the macro to copy paste the spreadsheet, but then will the various dropdowns and formulas work? Anyway back to the crux of the question. Date formula running from 15th to 15th. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date formula
I'm not sure how you're defining the starting point, but if you want to
start from the 15th of the month of a date specified in F1, then A1 is =DATE(YEAR(F1),MONTH(F1),15) A2 is =A1+1 and downwards, until near the bottom of the list, where A28, for example, would be =IF(A27="","",IF(DAY(A27)=15,"",A27+1)) and copy down to at least A31. -- David Biddulph "Sunnyskies" wrote in message ... Morning, I need to build a spreadsheet that will have the date in a column, running from the 15th of one month to the 15th of the next month i.e. 07-01-15 to 07-02-15. I would like the date to be entered onto a Parameters sheet and that needs to flow to the spreadsheet. The problem is that the spreadsheet needs to be duplicated depending on the number of drivers I have on the parameters list. I have a macro to add a spreadsheet depending on the number of drivers. I can simply then just add to the macro to copy paste the spreadsheet, but then will the various dropdowns and formulas work? Anyway back to the crux of the question. Date formula running from 15th to 15th. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date formula
Thanks this works well
"David Biddulph" wrote: I'm not sure how you're defining the starting point, but if you want to start from the 15th of the month of a date specified in F1, then A1 is =DATE(YEAR(F1),MONTH(F1),15) A2 is =A1+1 and downwards, until near the bottom of the list, where A28, for example, would be =IF(A27="","",IF(DAY(A27)=15,"",A27+1)) and copy down to at least A31. -- David Biddulph "Sunnyskies" wrote in message ... Morning, I need to build a spreadsheet that will have the date in a column, running from the 15th of one month to the 15th of the next month i.e. 07-01-15 to 07-02-15. I would like the date to be entered onto a Parameters sheet and that needs to flow to the spreadsheet. The problem is that the spreadsheet needs to be duplicated depending on the number of drivers I have on the parameters list. I have a macro to add a spreadsheet depending on the number of drivers. I can simply then just add to the macro to copy paste the spreadsheet, but then will the various dropdowns and formulas work? Anyway back to the crux of the question. Date formula running from 15th to 15th. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Trending Formula Results by Date | Excel Worksheet Functions | |||
Year-to-date year to date formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions |