Company with different calendar year

mlbrenes

New Member
Joined
Jun 22, 2017
Messages
4
Hi everyone,

I've been looking for a solution but haven't been able to find one! I hope you can help!

My issue is that my company has a different calendar year, it starts in April and ends in March, I want to use the formula to get the Week Number however a simple WEEKNUM() is not useful in my case, any ideas???

Thanks!
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Watch MrExcel Video

Forum statistics

Threads
1,099,372
Messages
5,468,227
Members
406,574
Latest member
HeinrichPaul

This Week's Hot Topics

Top