Use the database to calculate. They're very good at date maths. I don't know the syntax for MySQL but in Postgres it's something like SELECT NOW() + interval '7 days';