Forum Discussion
Solved
Calendar Create (any year)
I'm trying to create a calendar in excel using the template "Calendar creator (any year) but it's not filling in the dates. It has some dates in January and 2 weeks in February but nothing i...
The template has 12 formulas that generate dates in mm/dd/yyyy format, i.e. for December:
=DATEVALUE("12/1/"&Calendar!$B$1)-WEEKDAY(DATEVALUE("12/1/"&Calendar!$B$1))+1If your dates are in i.e. dd/mm/yyyy format this explains why the template doesn't work for you
In the attached file the 12 formulas have been changed to generate dates that should work whatever your date format is
