I am creating a spreadsheet for a small business that has incoming cash
on a daily basis, and outgoing payments on a monthly basis, The
payments occur on the same date every month but what i want to be able
to do is create a formula that will automatically put in the payments
on a given day every month (each month being on a seperate sheet) I was
looking to create a daterange formula but connot seem to get it to work




=IF(TODAY()=(DAY(B2:I2)),TRUE,FALSE)

This is the formula i have used (B2:I2) being the date range ie

8/11/04 to 14/11/04




--
xlnovice
------------------------------------------------------------------------
xlnovice's Profile: http://www.excelforum.com/member.php...o&userid=16456
View this thread: http://www.excelforum.com/showthread...hreadid=278138