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

[saumyashah90]

hey piyush look at thiscompare today with

this

Date(MonthStart(Today(),0)+4,'DD-MM-YYYY')

[tresesco]

Try this:

=FirstSortedValue(DISTINCT date,NetWorkDays(MonthStart(date),date),5)

PFA

[saumyashah90]

try this

if(Weekday(Date(MonthStart(Today(),0)+4,'DD-MM-YYYY'))='Sat',Date(MonthStart(Today(),0)+6,'DD-MM-YYYY'),

if(Weekday(Date(MonthStart(Today(),0)+4,DD-MM-YYYY'))='Sun',Date(MonthStart(Today(),0)+5,'DD-MM-YYYY')))

[MayilVahanan]

HI
May be try like this also

If(Date = MonthStart(Date),Pick(Match(WeekDay(Date),'Sat','Sun')+1,Date(MonthStart(Date,0)+7,'DD-MM-YYYY'),Date(MonthStart(Date,0)+6,'DD-MM-YYYY'),Date(MonthStart(Date,0)+5,'DD-MM-YYYY')))

[#6]

Hi Piyush,

Here is the script you needed

DAY:
LOAD Date(Today()+RecNo()) as Date
AutoGenerate 365;

Left Join(DAY) LOAD
Date,
Month(Date) as Month,
WeekDay(Date) as Day,
If(Date=LastWorkDate(MonthStart(Date),5),1,0) as FifthWorkingDay
Resident DAY;

Regards

GowriShankar

[#7]

Hi Mayil,

Expression is correct but not showing date.

Regards,

piyush

[jagan]

Hi,

Try Lastworkdate() like this

lastworkdate (MonthStart(DateDimensionName), 5))

Hope this helps you.

Regards,

Jagan.

[saumyashah90]

[MayilVahanan]

Hi

Try like this

lastworkdate (MonthStart(DateDimensionName), 5))

Hope tat helps