i have a worksheet for my flexi timesheet. it automatically populates the
dates for a month in collumn A based on the following formula:

=IF(MONTH($A$18)=MONTH($A$18+ROW()-18),$A$18+ROW()-18,"")

i want it to enter my usual hours in collumn N. but i want it to enter 0:00
if it is a weekend. i.e. IF A18 is a weekday enter 07:30 in cell N18, else
0:00

is this possible???

please help!

=IF(WEEKDAY(A18,2)<6,"07:00","0:00")

"Jenna" wrote:

i have a worksheet for my flexi timesheet. it automatically populates the
dates for a month in collumn A based on the following formula:

=IF(MONTH($A$18)=MONTH($A$18+ROW()-18),$A$18+ROW()-18,"")

i want it to enter my usual hours in collumn N. but i want it to enter 0:00
if it is a weekend. i.e. IF A18 is a weekday enter 07:30 in cell N18, else
0:00

is this possible???

please help!

=IF(WEEKDAY(A18,2)<6,"07:00","0:00")

"Jenna" wrote:

i have a worksheet for my flexi timesheet. it automatically populates the
dates for a month in collumn A based on the following formula:

=IF(MONTH($A$18)=MONTH($A$18+ROW()-18),$A$18+ROW()-18,"")

i want it to enter my usual hours in collumn N. but i want it to enter 0:00
if it is a weekend. i.e. IF A18 is a weekday enter 07:30 in cell N18, else
0:00

is this possible???

please help!