ExcelBanter - autofill on fixed dates

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - autofill on fixed dates (https://www.excelbanter.com/excel-worksheet-functions/135336-autofill-fixed-dates.html)

Guido Cole

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

David Biddulph[_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

All times are GMT +1. The time now is 08:24 PM.