On Cell A1 I have the date in question, in C1 I have a bunch of dates for the year, what I want to do is in Cell D1 and E1 have two formula that shows dates for specific times.
In D1 I want to have it where it shows all dates a week ahead of A1 and a month ahead in E1.
Is this possible?
could you attach a sample output that you are expecting? and would a VBA UDF work or do you want to stick to standard formulas?
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
I want standard formulas, and this is what I have so far, I've solved the issue in question so far, but now I've got to get it where the dates are between two ranges.
You'll see my solution so far, except I'm not sure how to make it work with a two date variable. I'm working on it as we speak so... Here is the file as it stands now.
Last edited by Cyberpawz; 04-17-2012 at 11:18 AM.
Ok, solved the issue, here it is, now I am perfecting everything else. Such as when dates are entered, the field in which the date is typed in via the list, the box in the calender will highlight.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks