Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula
how i create a formula in worksheet to change (weekly gross pay) Cell 'A"
into Cell 'B' (year to date) that should multiplies every week pay. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula
This only works if each week's pay is the same for the year. Assuming weekly
gross pay in cell A1, then in B1: =A1*WEEKNUM(DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW( ))),1) use ,1) at the end as shown if your weeks start on Sunday, use ,2) if your week starts on Monday. See Excel Help on WEEKNUM() for more information about it. If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in. "fireflash" wrote: how i create a formula in worksheet to change (weekly gross pay) Cell 'A" into Cell 'B' (year to date) that should multiplies every week pay. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Excel Formula Issue | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |