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