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.


--
Fifi
------------------------------------------------------------------------
Fifi's Profile: http://www.excelforum.com/member.php...o&userid=12325
View this thread: http://www.excelforum.com/showthread...hreadid=528566

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.




"Fifi" wrote in message
...

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.


--
Fifi
------------------------------------------------------------------------
Fifi's Profile:
http://www.excelforum.com/member.php...o&userid=12325
View this thread: http://www.excelforum.com/showthread...hreadid=528566