# Question dealing with IF

#### TheB

##### New Member
Hi,

I wish to do following but am having trouble building formula. Can someone help please.

I wish to add 1 to a cell(count) under the following condition.
If a range of cells(on same line) have a value of a day of week (ie. "Monday", "Tuesday", "Wednesday", "Thursday","Friday","Saturday","Sunday") then add 1 to this other cell. Basically counting days in a month for a timesheet calculation. I am only counting the number of week days in a month. Does anyone know how to achieve this? Better yet is there already a spreadsheet template out there that displays days of week for recording time which is dynamic without having to go in each month and change days? If not then an explanation of how to do above will help.

Thanks and look forward to your help.

...TheB

### Excel Facts

Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

#### Brian from Maui

##### MrExcel MVP
TheB said:
Hi,

I wish to do following but am having trouble building formula. Can someone help please.

I wish to add 1 to a cell(count) under the following condition.
If a range of cells(on same line) have a value of a day of week (ie. "Monday", "Tuesday", "Wednesday", "Thursday","Friday","Saturday","Sunday") then add 1 to this other cell. Basically counting days in a month for a timesheet calculation. I am only counting the number of week days in a month. Does anyone know how to achieve this? Better yet is there already a spreadsheet template out there that displays days of week for recording time which is dynamic without having to go in each month and change days? If not then an explanation of how to do above will help.

Thanks and look forward to your help.

...TheB

Care to post a small sample of your table with expected results?

Replies
3
Views
236
Replies
1
Views
122
Replies
4
Views
255
Replies
5
Views
480
Replies
0
Views
541

1,195,588
Messages
6,010,606
Members
441,558
Latest member
lambierules

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back