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 9th selling day (N19) of the month and the 60th selling day of the year (N20).
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 4th and November 24th, 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.