Him quick question is there any way of changing a cells date automatically depending on the date,
what im trying to do is work a money in and out spreadsheet
i use the =today() in a1 as a date stamp and what i have is a list of payees and what date they come out, i want to use a conditional format to colour the cells once the date passes but also i want the sheet to up date each month as in
payee 1 £50 29/12/2010
but as soon as my =today() turns to the 1/01/2011 then the payee 1 date jumps to the 29/01/2011 so on through the list of payees
Bookmarks