last working days

[#1]

if(len([Date Closed])<=0,now(),[Date Closed]) as DT2

Instead of Now() i want to find last working days of [date closed] month.

the date format is- 'mm/dd/yy hh:mi am/pm'

[swuehl]

Ok, thank you for uploading the excel.

I think we are talking about these records

Ticket Type	Ticket No	Date Raised	Assigned to group	Service name	Closed by	Date Resolved	Severity	Status	Depicts
A	187576-T	03.09.2015 13:35		System Portal	S KC		1	Open	Deployment
A	187548-T	03.09.2015 08:47		System Portal	S KC		1	Open	Deployment
A	187509-T	02.09.2015 13:37		System Portal	S KC		1	Open	Deployment
A	187465-T	01.09.2015 16:13		Clearcase	S KC		2	Open	Deployment
A	187435-T	01.09.2015 10:14		Clearcase	S KC		2	Open	Deployment
A	187380-T	27.08.2015 16:17		System Portal	S KC		2	Open	Deployment
A	187232-T	25.08.2015 12:34		System Portal	S KC		2	Open	Deployment

Could you please tell us which date you want to see in [Date Resolved] for each record if not Now() / Today() or End of Today's Month / Last working date of today's month?

[#3]

yes you are right.

Here all the ticket resolved in sep except open one.

so i need to consider end working day of date resolved