D
dido22
Hello.
I am developing a workbook to track my finances.
One sheet has a list of all my expected bills with their start dates. Some
bills are quarterly, eg telephone. Before adding/subtractiong these to my
current account I need to test that today's date is 3,6,9,12,15 etc etc
months after the start date. I know how to use IF functions, but the formula
I am getting is very messy. Is there an elegant way of doing this?
Thanks for all ideas, I use excel 2007
KK
I am developing a workbook to track my finances.
One sheet has a list of all my expected bills with their start dates. Some
bills are quarterly, eg telephone. Before adding/subtractiong these to my
current account I need to test that today's date is 3,6,9,12,15 etc etc
months after the start date. I know how to use IF functions, but the formula
I am getting is very messy. Is there an elegant way of doing this?
Thanks for all ideas, I use excel 2007
KK