Announcements
cancel
Showing results for
Did you mean:
Not applicable

## Extract 5th working day of Month.

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

1 Solution

Accepted Solutions
Specialist

15 Replies
Specialist

hey piyush look at thiscompare today with

this

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

MVP

Try this:

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

PFA

Specialist

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')))

MVP

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')))

Thanks & Regards, Mayil Vahanan R
Not applicable
Author

Hi Piyush,

Here is the script you needed

DAY:
AutoGenerate 365;

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

Regards

GowriShankar

Not applicable
Author

Hi Mayil,

Expression is correct but not showing date.

Regards,

piyush

Luminary Alumni

Hi,

Try Lastworkdate() like this

lastworkdate (MonthStart(DateDimensionName), 5))

Hope this helps you.

Regards,

Jagan.

Specialist

MVP

Hi

Try like this

lastworkdate (MonthStart(DateDimensionName), 5))

Hope tat helps

Thanks & Regards, Mayil Vahanan R