Just add some code in the macro

If Weekday(Date) = 2 Then
'add C2
ElseIf Weeklday(Date) = 6 Then
'add C5
End If

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
ps.com...
Have been trying to execute macros on certain weekday have got it to
work to display me a message box based on an earlier thread but I would
like to add to cell c2 if its a monday and add some values to cell c5
if its a friday. is there a way to do that? thanks