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 in the rest of the squares. When I change the year at the top those dates the dates that appear change but no other dates appear. I've looked at formatting the cells but they are all formated the same.
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
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
