Hi everyone,
I'm wondering if anyone has written a formula that returns any dates that occur between today and the next 30 days. This is what I tried:
=SMALL(IF(and(DATA!$D$2:$D$9>=TODAY(), DATA!$D$2:$D$9<TODAY()+30),DATA!$D$2:$D$9),3)
Any help is greatly appreciated!
Alex
Not sure what are you trying to do, but try this......
In any cell of your choice......
and copy down until you get blank cells and format as dates.
Please Login or Register to view this content.
This will give you next 30 dates after today's date.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Not quite what I am looking for. I have a list of dates and I just want to return the dates from my list that occur in the next 30 days.
Try this Array Formula. Since this is an Array Formula so you need to confirm it with Ctrl+Shift+Enter instead of just Enter.
Assuming your dates are in the range D2:D9, then
Enter the formula with Ctrl+Shift+Enter and copy down until you get blank cells.Please Login or Register to view this content.
Is this what you are trying to achieve?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks