Auto generated dates

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.

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" <Fifi.25jhun_1143817802.4609@excelforum-nospam.com> wrote in message
news:Fifi.25jhun_1143817802.4609@excelforum-nospam.com...
>
> 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
>