Calculate Age without weekends

griseldagomes

Hello Experts,

I am looking to calculate the age for a set of data where I have the record date which needs to be deducted from current date to get the age, post excluding weekends (Saturday and Sunday).

Assuming today is 25th Mar, below is the expected age for the mentioned dates.
How can I achieve this please?

Record Date	Age
18-03-2024	5
19-03-2024	4
20-03-2024	3
21-03-2024	2
22-03-2024	1

JosephSerpis

Hi @griseldagomes you can use the generate row tool to generate all the dates from your data and today date and then filter out Saturday and Sunday then aggregate the data. I have came up with an approach which showcase this. 

Dates_24032024.yxmd