Thread
:
Sundays
View Single Post
#
6
Posted to microsoft.public.excel.worksheet.functions
T. Valko
external usenet poster
Posts: 15,768
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
Reply With Quote
T. Valko
View Public Profile
Find all posts by T. Valko