| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
autofill on fixed dates
In colum A I have a series of dates, in C1 I have a fixed value. I want this
value to appear in colum B on each 15th and 30th of the month. How can I programm the function in colum B? Thanks for any help. Guido |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
autofill on fixed dates
=IF(OR(DAY(A2)=15,DAY(A2)=30),C$1,"")
-- David Biddulph "Guido Cole" wrote in message ... In colum A I have a series of dates, in C1 I have a fixed value. I want this value to appear in colum B on each 15th and 30th of the month. How can I programm the function in colum B? Thanks for any help. Guido |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can autofill, as in months or dates, go to the end of the spreads | Excel Worksheet Functions | |||
| drawdown at fixed rate over set period from investment at fixed % | New Users to Excel | |||
| autofill next sheet with next set of dates | Excel Worksheet Functions | |||
| Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) | |||
| Charting data against dates where dates are not at fixed intervals | Charts and Charting in Excel | |||
Hybrid Mode
