if the 15th of the month falls between two dates, calculate, otherwise 0

Hi,

This is my first post and I hope someone is able to help. I have a spreadsheet that tracks my banking expenditure by fortnight. However, there are some transactions that happen automatically on a particular day each month.

Each column heading is the start date of each fortnight.

What I am trying to do is for a cell to have a formula in it that determines if a particular day of the month (say the 15th) falls between two column heading dates and, if so, carries out a transaction, otherwise returns zero.

I've seen some formulas that use the =IF(AND... functions, but I've not been able to find out a way to change it to fit my needs.

Hope someone can help.

Cheers

Hurleyinoz

It would help if you attached a sample workbook, then we could see which columns you are using. The FAQ describes how to.

Pete

Originally Posted by daddylonglegs

Here's one way, assuming fortnight start date in B1

=IF(SUM(0+(DAY(B1+{0,1,2,3,4,5,6,7,8,9,10,11,12,13})=15)),"yes","no")

you can copy the formula across

Thanks for this info Daddylonglegs

Is there a way to refer to the 0-13 numbers as a series rather than having them all listed like that?