Per Diem Caculation
You can actually use
=SUMPRODUCT(25*(WEEKDAY(A2:A32,2)5))
--
Regards,
Peo Sjoblom
"Peo Sjoblom" wrote in message
...
I need to know more how the design looks, do you have all dates in the
same
row/column that you can use a
formula for weekend days. Assume the dates are in A2:A32
=SUMPRODUCT(--(WEEKDAY(A2:A32,2)5))*25
will count the weekends then multiply them with 25
just change the range to fit
I tested for Jan 04 and it returned $225.00
--
Regards,
Peo Sjoblom
wrote in message
...
I am writing a spreadsheet to figure Travel Vouchers for
myself and my Army classmates. I've everything except for
Meal payments on weekends. Got the date converted to day
of week using "ddd." We are allowed $28 per Sat & Sun for
meals here in Georgia. Any (easy) suggestions?
SFC Pelletier
very novice Excel user.
|