I have a spreadsheet with the columns labels date (A), work done, hours (D).
I want to have excel calculate the number of hours spent during a week to be able to sum up. The number of entries made per week can vary so I was going to have excel calculate in another column either the hours listed in D or enter a 0 which I can then sum to get the hours worked per week. I tried using the following formula but am getting an error. Can someone help me with what I am missing.
Thanks
=IF((OR(A5=DATEVALUE("04/06/2014"), A5=DATEVALUE("04/07/2014"), A5=DATEVALUE("04/08/2014"), A5=DATEVALUE("04/09/2014"), A5=DATEVALUE("04/10/2014"), A5=DATEVALUE("04/11/2014"), A5=DATEVALUE("04/12/2014")),D5,0)