When the user inputs a max date and min date, how do you check whether or not the date in the spreadsheet falls between the beginning and ending date?
When the user inputs a max date and min date, how do you check whether or not the date in the spreadsheet falls between the beginning and ending date?
Try using a formula like
=AND(date<=Max_date,date>=Min_date)
Audere est facere
oh, sorry but I want it in VBA though
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks