Creating a Progressing Calendar with a Year Look Up

**MarvinP** · 01-13-2017, 05:28 PM

Hi Crispy,

Are there hidden sheets in the workbook?
https://support.office.com/en-us/art...d-58cd2c7516de

Does the file have any VBA behind it? Press Alt-F11 and see if there is VBA code behind the sheets or in modules.

**CrispyBenFranklin** · 01-13-2017, 05:50 PM

Hi Marvin,

Thanks for the quick reply!

There were hidden sheets, but it was just the two years previous, still no data dump. I'm looking at the VBA properties list for the worksheet, but I can't find anything regarding a code, what am I looking for?

I'm not sure if this is helpful, but this is the formula on each day of the calendar:

=IF(AND(YEAR(FebSun1+1)=TheYear,MONTH(FebSun1+1)=2),FebSun1+1, "")

Thanks!

Creating a Progressing Calendar with a Year Look Up

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: Creating a Progressing Calendar with a Year Look Up

Re: Creating a Progressing Calendar with a Year Look Up

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Creating calendar item in non-default calendar

Calendar Template Duplicating My Entries (Year On Year)

[SOLVED] Need help with Calendar formula for previous year and next year

Transpose Quarters from Calendar Year to Fiscal Year

Input a year to determine the start date for 4-4-5 Calendar Year.

Convert from Fiscal Year to Calendar Year

[SOLVED] change the year in a calendar template to different year

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions