If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Per Diem Caculation
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. |
#2
|
|||
|
|||
Per Diem Caculation
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
Per Diem Caculation
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 -----Original Message----- 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. . |
#5
|
|||
|
|||
Per Diem Caculation
My Pleasure..
-- Regards, Peo Sjoblom "SFC Pelletier" wrote in message ... 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 -----Original Message----- 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. . |
Thread Tools | |
Display Modes | |
|
|