Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Is this possible, if so how?
Thanks in advance.
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?