Sundays

M

Maresa

I dl a timesheet template where the date is formatted to say Sunday, Monday
etc. (Eg 40017 displays Thursday in column A5 and 23/07/09 in column B5)

I need a value of 1 in colum J5 if A5 = Sunday AND there is a value >0 in
column H5
Currently the spreadsheet looks like this:
A = Weekday
B= Date
C= Start work
D= End work
H= Daily hours worked
J = Sundays worked
 
J

Jacob Skaria

Try the below
=IF(AND(WEEKDAY(A5)=1,A5>0,H5>0),1,0)

If this post helps click Yes
 
T

T. Valko

=(MOD(A5,7)=1)*(H5>0)

That only works if you're using the 1900 date system. Safer to use the
WEEKDAY function.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count specific weedays remaining in quarter 4
Finding the right function & formula 4
If C2 is Sunday how do I make D 2 to the next day of the week 2
data from 1 sheet to the next 6
Prevent functions from changing when new rows are added 1
Count the Number of Weekdays by Month 3
VLOOKUP & IF used with > or < 7
Sumproduct W-t-d 4

Top