Per Diem Caculation

[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.

 

[Peo Sjoblom]

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

 

[Peo Sjoblom]

You can actually use

=SUMPRODUCT(25*(WEEKDAY(A2:A32,2)>5))

 

[SFC Pelletier]

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

 

[Peo Sjoblom]

My Pleasure..

--

Regards,

Peo Sjoblom

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