Not having a lot of background experience with formulas, I am having difficulty determining whether or not the NETWORKDAYS formula can be "adjusted" to include an allowance for half-days.
Using the Vacation template, it calculates the number from start to end days. I have added a check-box column for half-days. If this box is checked, I want it to subtract .5 days from the 1 day total (created by the NETWORKDAYS formula). Clearly I am doing something wrong because the formula comes back as UNPARSEABLE.
Is it possible to create the formula noted above and, if so, where am I going wrong with the formula below?
=(NETWORKDAYS([Start Date]63, [End Date]63) - IF([Half-day]63, .5_if_true, 0_if_false))
Thanks in advance!