Having Issues With Calculating Dates

[YuriyBaron]

Hi,

The formula that I am using is NETWORKDAYS([@[Start date]],[@[End date]],lstHolidays)
The results are inconsistent.

What I am trying to do is have every day count as 1 day. So that if:
Start Date and End Date are the same, it is one day
Today - Today = 1
Today - Yesterday = 2
Today - 2 days ago = 3

I also have 1/2 days that I would like to show up as 0.5. It would be nice if that could be included in the formula.

The attached spreadsheet has an example.

Thank you

[AliGW]

Your holiday date loist isn't in the workbook ...

[AliGW]

Try this:

=IF([@[Start date]]=[@[End date]],1,NETWORKDAYS([@[Start date]],[@[End date]],lstHolidays))*IF([@[Type of leave]]="Half Day",0.5,1)

[YuriyBaron]

This has fixed everything. Thank you for your help.

[AliGW]

Glad to have helped.

If you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.