Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Month Timetable on a worksheet different month each works | Excel Worksheet Functions | |||
End of month calculations | Excel Discussion (Misc queries) | |||
Month to date calculations | Excel Worksheet Functions | |||
When using MONTH function on Blank Cell!! Returns Month=Jan! | Excel Discussion (Misc queries) | |||
transfer cell $ amount to other sheet month-to-month without overc | Excel Discussion (Misc queries) |