Auto generated dates

F

Fifi

I am looking for a way to auto generate an audit due date. For example,
if the audit is done today and its frequency is every 13 weeks. I like
to generate the next due date. So, I will have a column of "done date"
"frequency" and "Next due date". Any help will be appreciated.
 
G

Guest

Hi

If your dates are Excel dates, you can just use standard maths. If you have
31/03/06 in A2 and 13 in B2, you can use
=A2+(B2*7)
which will take your 'weeks' figure and multiply it by 7.
Format the result as date.

Hope this helps.
Andy.
 
Top