Date Forumla

[jassa]

im currently stuck on excel spreadsheet with this problem.

for example cell a is full of date dd/mm/yyyy what i want to do is use this field to solve the two conditions below.

If the day in the date column falls on a weekend, populate the field with a 1, otherwise 0

If the day in the date column is a Saturday, populate the column with SAT otherwise leave blank.

any ideas or thoughts

[VBA Noob]

Not sure if this is what your after

=IF(WEEKDAY(A1)=7,"Sat",IF(WEEKDAY(A1)=1,1,0))

You say you want a 1 for a weekend and Sat for Sat. Do you want both ??

VBA Noon

[VBA Noob]

Please read forum rules. Reply to people in thread and not by PM them.

Does this help.

=IF(OR(WEEKDAY(A1)=7,WEEKDAY(A1)=1),1,0)

VBA Noob

[jassa]

thank you very much !!!