LinkBack URL
About LinkBacks
campersand 
With an helpcolumn
G2=After that you can filter on Yes or make an pivot table of the data.
=if(and(Day(C2)&"-"&Month(C2)<=DAY(today())+3&"-"&Month(today()),DAY(C2)&"-"&Month(C2)>=DAY(today())&"-"&Month(today())),"YES","")
See the attached file.
With an helpcolumn
G2=After that you can filter on Yes or make an pivot table of the data.=if(and(Day(C2)&"-"&Month(C2)<=DAY(today())+3&"-"&Month(today()),DAY(C2)&"-"&Month(C2)>=DAY(today())&"-"&Month(today())),"YES","")
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks