LinkBack URL
About LinkBacks
I need to find the most recent date given the following:
1. Start date.
2. Interval in weeks between occurrences.
Result. the most recent occurrence.
I need to find the most recent date given the following:
1. Start date.
2. Interval in weeks between occurrences.
Result. the most recent occurrence.
You will need to give much more info and data than that. Keep in mind that we have NO clue what you want, what you are working with, and what need to be done.
Upload a small sample workbook, showing before and after
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I'll try to create a small sample. I tried to attach the uploaded file, but it wouldn't move to the bottom of the dialog.
Date (formated as dd/mm/YYYY) Interval (number of weeks for the event to repeat) Most recent occurrence of the event
03/02/2011 1 01/13/2016
11/15/2015 3 01/15/2016
The most recent occurrence is what I'm trying to calculate. I only need to do it one time. We have a job that failed to run and I need to find the instances that should have run last week.
Row\Col C3: =A3 + (7 * B3) * INT((TODAY() - A3) / (7 * B3))
Last edited by shg; 01-16-2016 at 09:13 PM.
Entia non sunt multiplicanda sine necessitate
Thanks... that worked.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks