I am trying to make a calendar list that shows the months, week numbers, and the day numbers within the month and the weeks. Where there is information in one column, I don’t want any info in the other columns, meaning the row only has one piece of information. Here is a spreadsheet that can be manipulated as it’s a copy: https://docs.google.com/spreadsheets/d/1EKpSzuT0_pUytBCaga80LWExRNqDcuh2iGrV5Rg_hdA/edit?usp=sharing
I was filling this out manually, but I know that there is a way to autopopulate, but can’t figure it out. I have formulas to fill out other calendars and such, but the jumps in the info is throwing me off.
Tiffany Aguirre is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.