Forum Discussion
Dynamic Calendar Date Returning #REF! Issue
Hello, I'm attempting to create a dynamic calendar and am running into an issue with the dates populating correctly. The good news is I've moved from a #VALUE error to a #REF! error but still...c...
What is E29(ScYear,SelMonth,1) in your formula. You can use cell reference in this way. Do you mean Date(ScYear,SelMonth,1) or =IF(WEEKDAY(DATE(ScYear,SelMonth,1),1)=E29,Date(ScYear,SelMonth,1),""). What result do you expect in E8 cell?
I think the latter. The goal is that the Weekday Start on E3 can be switched and the calendar itself will populate the dates automatically, either leaving the square blank if the month doesn't start until later in the week, or fill in the date (1, 2, 3, etc.) otherwise. Does that make sense?