Per Diem Caculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Sir,your formula work very well. I have the days in a
columnar format. Now to adjust for Federal Holidays, which
are non-training dates, and I'll be able to share the sheet
with my class mates. You have saved much time for us. This
will assist us getting the documentation submited with in
the 5 day limit we have. This US Army Seargent salutes
you. Thank You
 
My Pleasure..

--

Regards,

Peo Sjoblom

SFC Pelletier said:
Sir,your formula work very well. I have the days in a
columnar format. Now to adjust for Federal Holidays, which
are non-training dates, and I'll be able to share the sheet
with my class mates. You have saved much time for us. This
will assist us getting the documentation submited with in
the 5 day limit we have. This US Army Seargent salutes
you. Thank You
Click to expand...
 
Back
Top