Thread: Sundays
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Sundays

=(MOD(A5,7)=1)*(H50)

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

--
Biff
Microsoft Excel MVP


"Bernd P" wrote in message
...
=(MOD(A5,7)=1)*(H50)

Regards,
Bernd