Automatic calculation of calendar days - Is it possible?

(1) Share

Report

Posted on by PowerSäm

775

Hello everyone,

I have built an app that makes it possible to fill out vacation requests. So now I have in the tab "Period" the vacation start and the vacation end. There I can select the days with the calendar option. Next to it I have a field that defines the number of vacation days.

Now I want the app to automatically count the days from one date to the next and enter them in the field. Is this possible?

For example:

Vacation start: 02/09/21
Vacation end: 05/09/21
Number of days: Vacation end - Vacation start (automatically)

Best of all, of course, the weekends, that is, Saturday and Sunday are omitted, because you take no vacation.

Is this somehow possible or is this asking too much?

Thanks in advance to all!

Categories:

Building Power Apps

I have the same question (0)

All responses (16)

Answers (4)

Verified answer

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (1)

Report

Hey. Use datediff

https://docs.microsoft.com/pt-pt/powerapps/maker/canvas-apps/functions/function-dateadd-datediff

DateDiff(DatePicker.SelectedDate; DatePicker2.SelectedDate; Days)

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Was this reply helpful? Yes No
Verified answer

Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (1)

Report

Hi @PowerSäm,

You can try DateDiff() Operation.

DateDiff(DateField1.SelectedDate, DateField2.SelectedDate,Days)

to Avoid Negative if startdate is greater than end Date you can try below one

If(DateDiff(DateField1.SelectedDate, DateField2.SelectedDate,Days)<0,
DateDiff(DateField1.SelectedDate, DateField2.SelectedDate,Days)*-1,
DateDiff(DateField1.SelectedDate, DateField2.SelectedDate,Days))

Please mark as Answer if it is helpful and provide Kudos
https://microsoftcrmtechie.blogspot.com
https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA

Was this reply helpful? Yes No
Verified answer

timl 36,383 Super User 2025 Season 2 on at

Like (2)

Report
Hi @PowerSäm

This will give the answer, excluding Saturdays and Sundays. You would replace the hardcoded dates with references to your date pickers.

With({ startDate:DateValue("2021-09-02"), endDate:DateValue("2021-09-05") }, RoundDown(DateDiff(startDate, endDate, Days) / 7, 0) * 5 + Mod(5 + Weekday(endDate) - Weekday(startDate), 5) )

Here, the answer is 1 day (the difference between 02/09 and 03/09 because 04/09 and 05/09 are weekends).

You might also want to vote for my idea here, which is to provide an easier way to calculated working days.

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Provide-a-function-to-add-or-subtract-working-days-excluding/idi-p/789366

Was this reply helpful? Yes No
PowerSäm 775 on at

Like (1)

Report

@rampprakash @Nogueira1306 Thanks for your quick reply.

This works so far. But now I want that if you enter a date as start date, you can not enter a date as end date, which takes place before the start date. that means, you can only enter as end date a date that comes after the start date.

I hope it was explained clearly enough.
Thanks in advance!

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (1)

Report

After you select the date, check if

DatePicker1.SelectedDate < DatePicker2.SelectedDate

If yes, Notify the user and reset the datepicker maybe. If not, go ahead

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Was this reply helpful? Yes No
PowerSäm 775 on at

Like (1)

Report

@Nogueira1306 Thanks for your replay!

Where do I put it? In Onselect or DefaultDate?

Thanks in advance!

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report

None of that. OnChange

Or, if that is a form, before submiting

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Was this reply helpful? Yes No
PowerSäm 775 on at

Like (1)

Report

@Nogueira1306 @rampprakash Thanks for your reply.

That works so far, now however still another small attitude thing. If I select the 06/09 as the start date and the 07/09 as the end date, it shows me only one day in the number of days, but in reality there are two, do I have to insert a +1 somewhere?

Thanks in advance!

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (1)

Report

Yes. On that label, set it to be the dateidd + 1

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Was this reply helpful? Yes No
PowerSäm 775 on at

Like (1)

Report

@Nogueira1306 Thanks for your reply!

It is a text input box. Only unfortunately I did not understand where I have to enter it?
The +1 somewhere under Default somewhere.

Thnak you in advance!

Was this reply helpful? Yes No