A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Per Diem Caculation



 
 
Thread Tools Display Modes
  #1  
Old March 6th, 2004, 10:52 PM
external usenet poster
 
Posts: n/a
Default 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  
Old March 6th, 2004, 11:53 PM
Peo Sjoblom
external usenet poster
 
Posts: n/a
Default 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  
Old March 7th, 2004, 12:32 AM
Peo Sjoblom
external usenet poster
 
Posts: n/a
Default 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  
Old March 7th, 2004, 12:48 AM
SFC Pelletier
external usenet poster
 
Posts: n/a
Default 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  
Old March 7th, 2004, 01:38 AM
Peo Sjoblom
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:50 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.