First Monday of Month/Quarter

[#1]

How to  write an expression to calculate number of sales on first specific weekday (Monday) of month/Quarter?

[shree909]

try something like this using weekday function.

if(  weekday(month)='monday', count(sales),null())

if(  weekday(month_number)='monday', count(sales),null())

[#3]

Hi Shree,

             thanks for reply.I want to calculate only for first monday of each month/Quarter.

[MayilVahanan]

Hi

Try like this

=if(Day(Date) <= 7 and WeekDay(Date) = 'Mon',Sum(Sales))

May be that helps