Hello everyone.
I would much appreciate your help for the following: I have a table where I would like to show only the Contracts with dates from 2016 to TODAY + 90 days. Is there a way to do it? I have been playing for a while with filters without managing
Thanks a lot
Hi there.
Probably... but...
A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.
Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
You are more than right
In a nutshell: I would like to filter in Column G and showing only the projects expiring in 3 months (today + 90 days)
Thank you again
easiest way. In cell H3:
=G3>=TODAY()+90
drag down. Filter on TRUE by this new column
<----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.
Thanks for this but I need to do it in a pivot table so such an option doens't fit
you can make it work, see attachment
That's great! Thanks a lot
Hello my friends
I have a problem with dates
I want to minus a date from another date but I can't adjust the answer as I want:
plz see the pictureAttachment 785838
Originally Posted by mmzare
Administrative Note:
Welcome to the forum mmzare
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.
Please see Forum Rule #4 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks