Extract 5th working day of Month.

[#1]

hi,

I have a condition which becomes true when toady is fift working of day of month. how to extract fifth working day of month.please help.

Regards,

Piyush Jain

[#2]

Hi,

This is good but if saturday and sunday lies between 1 to 5th and saturday on fifth day or sunday on fifth day then fith working day shift to 6 or 7th of that month.

Regards,

piyush

[MayilVahanan]

HI

Can you share sample file?

[jagan]

Hi Piyush,

Try like this

=MakeDate(Year(DateDimension), Month(DimensionName), 5)

Hope this helps you.

Regards,

Jagan.

[MayilVahanan]

Hi
Try like this

Let vEnd = Num(Today(1));

Let vStart = Num(YearStart($(vEnd),-4)) - 1;

Generate:

LOAD Date($(vStart) + IterNo()) AS Date , num((rand() * 100) + 1000, '##0') as Sales

AutoGenerate 1

While ($(vStart) + IterNo()) <= $(vEnd);

Tablename:

Load *, If(Date = MonthStart(Date),Pick(Match(WeekDay(Date),'Sat','Sun')+1,Date(MonthStart(Date,0)+6,'DD-MM-YYYY'),Date(MonthStart(Date,0)+6,'DD-MM-YYYY'),Date(MonthStart(Date,0)+5,'DD-MM-YYYY'))) As FifthWorkingDay;

LOAD Year(Date) AS Year,Date,Day(Date) AS Day,Num(Date) as DateNUm ,WeekDay(Date) as Week,MonthName(Date) AS MonthYear

Resident Generate ;

[saumyashah90 · Accepted solution]

this will solve your question

[#7]

Hi,

I have to extract 5 day from formula =networkdays(Monthstart( today() ),Monthend( today() )).

Regards,

Piyush Jain