Sorry for the double post. Can I use a formula to format calendars year-round. For example if the first of April is a Tuesday, can I use a formula to automatically place a 1 in the Tuesday cell. Please let me know if I am not being clear enough. I appreciate the help.