Excel Formula

F

fireflash

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

JLatham

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