month calculations
I am trying to set up a spredsheet to calculate my finances and i have some
direct debits that come up quartely and some bi monthly. I want the
spreadsheet to work out when.
So if one comes up today 31/3/07 and is due up in 3 months how can i get it
to work out when i.e. 30/6/07. I dont want to have to sit with a calander and
work out how many days it is and add them t the current cell.
Also leading on from that how could i tell it i get paid on the last day of
the month and have it work it out. i.e. 28/2, 31/3 etc
|