Chris Davison
MrExcel MVP
- Joined
- Feb 15, 2002
- Messages
- 1,790
Evening All,
on behalf of Jack in the UK :
what's the formula for incrementing a cell with a date in it by a whole year (taking into account leap years)
so : 31/07/2002 plus a year would always be 31/07/2003
scource cell is formatted as a date dd/mm/yyyy - I can't just add 365 as this will trip up on leap years
thanks
Jack in the UK
on behalf of Jack in the UK :
what's the formula for incrementing a cell with a date in it by a whole year (taking into account leap years)
so : 31/07/2002 plus a year would always be 31/07/2003
scource cell is formatted as a date dd/mm/yyyy - I can't just add 365 as this will trip up on leap years
thanks
Jack in the UK