I created one by just imputing the numbers but it took a very long time. Is there a better/faster way to do this. Thanks for any help

There are numerous free and paid calendar tools and templates for Excel available through the Internet. For example, see Excel Calendar Templates or search for "Excel calendar" at your favorite search engine.

Thanks, I have seen the templates. I was more trying to create my own and understand the formula.

Define what you mean by a calendar. What formulas are you referring to?

Joe,

Here are some date related formulas:
=Now() This inserts the current day on your spreadsheet. You can format it to show the date only or date and time.

If you have a date in one cell. You can add a number to it to get another date. For example, if you have October 30 in cell A1. You can enter a formula in another cell in your spreadsheet (example B1) like this: =A1+7

The formula will give you date 7 days from October 30 or November 6