Week Number

thestones757

New Member
Joined
Feb 24, 2010
Messages
24
I have an excel sheet for paychecks for total hours and i use the weeknumber function to total up paychecks that i should be getting and compare with actual, however the weeknum function that i use i can only get to start on monday or sunday, but i need the week to start over on friday how do i do this? please help! thanks
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Watch MrExcel Video

Forum statistics

Threads
1,099,115
Messages
5,466,770
Members
406,499
Latest member
COACHTEEJ

This Week's Hot Topics

Top