Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
week entry new
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
week entry new
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 --------------- Jacob Skaria "aditya" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
week entry new
Hi
I take it that you meant 28 Mar 10 in A2. If so, then =INT((A1-"01/04/2009")/7)+1 -- Regards Roger Govier "aditya" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
week entry new
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 -- David Biddulph "aditya" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
week entry | Excel Discussion (Misc queries) | |||
week entry | Excel Discussion (Misc queries) | |||
Automatically Insert Dates For Week Off One Day Entry | Excel Discussion (Misc queries) | |||
Date Entry in 1 Cell with result populating for entire week in ano | Excel Discussion (Misc queries) | |||
day of the week entry automatically | Excel Worksheet Functions |