Thanks Ray, I just came back here to say I'd worked it out when I saw your reply - I normally get an email when you reply to posts so not sure why I didn't this time. Anyway, just to confirm that's what I did to get it to work. Ideally I'd like it to return the last day of the month 3 months from now rather than an 'absolute' date (i.e. 3 months from 30 November gives 2 March and not 28 February) but I'm not sure if that's possible?