Calendar Object to select all data for Current Month or preceding 3
Hi,
I'm trying to create a calendar object where the user can select a Year & Month, displayed as one ('2015 January', '2014 December', etc) and the table will return all data for that Month. When the user navigates to the sheet, the calendar should default to the Current year/Month, based on yesterday's date and then limit the the possible selections the either current month or 1 of the preceding 3.
Hi, I'm facing a similar question. I'm trying to show a formula that tabulates the counts for the preceding 2 and 3 months respectively. Did you manage to get the formula for preceding month's count?
