I am fairly new to Excel and I am trying to create a working formula that will show the current selling day of the month as well as the current selling day for the year. I work at a dealership that is open Monday through Saturday as a regular work week. I am trying to create a formula that will do the following:

If =TODAY() is 3/10/2016, using the chart below as a reference it would be the 9^{th} selling day (N19) of the month and the 60^{th} selling day of the year (N20).

[ATTACH=CONFIG]68547[/ATTACH]

A1 will say “CURRENT DATE:”

A2 will show “=TODAY()”

B1 will say “SELLING DAY OF MONTH”

In B2 I am trying to create a formula to calculate what selling day of the month it is.

C1 will say “SELLING DAY OF THE YEAR”

In C2 I am trying to create a formula to calculate what selling day of the year it is.

In this particular calendar year, we are closed on July 4^{th} and November 24^{th}, as well as each Sunday. So there are only 312 actual selling days for the year

I have tried using the NETWORKDAYS.INTL, but I am not quite sure of what I am doing. Once I have figured out how to create these two formulas, I can create other simpler formulas that calculate the overall selling pace that we are on for the current month and current year.

I look forward to any assistance in this area.

DVSWINDLER