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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|