week entry new

A

aditya

if in cell A1 date is given, how can i do week entry of financial year in
cell B1.
note: financial year 1st APR to 31st March.

e.g.
A1=02-APR 09 B1=1st Week
A2=28 Mar 09 B2=52nd Week
 
J

Jacob Skaria

Hi Aditya

In B1 try

=ROUND(DATEDIF(DATE(IF(MONTH(A1)<4,YEAR(A1)-1,YEAR(A1)),4,1),A1,"d")/7,0)+1

If this post helps click Yes
 
R

Roger Govier

Hi

I take it that you meant 28 Mar 10 in A2.
If so, then
=INT((A1-"01/04/2009")/7)+1
 
D

David Biddulph

How do you define your weeks?
Does week 1 run from 1st to 7th of March, or is it dependent on the day of
the week?
If the former, perhaps =INT((A1-DATE(YEAR(A1)-(MONTH(A1)<4),4,1))/7)+1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

week entry 1
simple week entry 2
week entry 1
Formula IF 1
Financial Year Weeknum 1
Find the position of a date 6
VBA Coding Help for Beginner 0
Count If formula with week range 9

Top