A member of another forum has a query over excel, can anyone help?
OK I have a spreadsheet thing which amounts to when the team members need their car park passes renewed (though annually, they are all at different times).
What I want to be able to do is have a column, for instance Column D, listing when the pass was issued - say 05-11-08, this stays fixed. On the 5th November, the next column, Column E, now needs to update itself to 05-11-09 (when the pass expires). Next year, that same Column E needs to update itself again to 31-10-10.
Can this be done?
What I want to be able to do is have a column, for instance Column D, listing when the pass was issued - say 05-11-08, this stays fixed. On the 5th November, the next column, Column E, now needs to update itself to 05-11-09 (when the pass expires). Next year, that same Column E needs to update itself again to 31-10-10.
Can this be done?