Saturday, April 9, 2011

Ends one week to create expense reports date expression method in Microsoft Excel is?

Let's say you are putting together use to your employees for all expense report sheet. Allow one week to enter end date is calculated automatically for the rest of the day of the week spreadsheet. We use two main formulas are as follows:

= IF (B1 "", IF (7 WEEKDAY (B1), B1+7-WEEKDAY (B1), B1), "")

= IF ($ b $ 2 "", $ b $ 2-6, "")

In cell B1 in the date blank if you do not () says at first (""), then go to the next part of the formula, and otherwise leave blank. Returns the number that identifies the date formula = weekday() 1 to 7 of the day. In this example, to February 12, 2010 end date as week selected. = weekday (B1) 6. So, add, and then if you don't get value equal to 7, with B1 Sunday B1, 6, 12, 19 for B1, 5 x 6. We end at 13. (Summary: 12 + 7 = 19 19 - 6 = 13. )? The date is February 13, 2010.

Each day of the following formula. Sunday's formula is: IF ($ b $ 2 "", $ b $ 2-6, "") to =. If B2 is insignificant and 6 draws, otherwise, blank. We give correct date Sunday, 07 February 2010 13-6 example 7 =. Monday formula: we give a 13-7 = IF ($ b $ 2 "", $ b $ 2-5, "") to 8 February till Saturday) = 8. One simple way is there to improve the expense report.

I just put it as a template, and also would work, but how many people tried, and how, understanding job time consuming to do you care to explain? Feel you learn a lot and trying to build yourself these spreadsheets to achieve much. Do you have any questions or comments please feel free to if they tell me.

Thanks for reading!

1 comment:

Richard C. Lambert said...

In addition to recording expenses, PocketExpense Pro can export the recorded data to a file for syncing with an MS-Excel spreadsheet as your printable expense report! project time tracker