A
Amedee Van Gasse
MahaRaj said:Hi I am working on this PAYSLIP sheet. I want to add this feature in
payslip to find out the Week NO. on the basis of w/e dates entered
which could be different from the standard table (below).
i.e If date enterd is 07/05/2004 then its lessthan 10/05/2004 and
greaterthan 03/05/2004 than week no=5
It would have been easy if the options were just 2, but how can i
evaluate it from the table(below)?
I do not know how to start! any ideas please
W/E Week No
12/04/2004 1
19/04/2004 2
26/04/2004 3
03/05/2004 4
10/05/2004 5
17/05/2004 6
24/05/2004 7
31/05/2004 8
07/06/2004 9
14/06/2004 10
21/06/2004 11
28/06/2004 12
05/07/2004 13
12/07/2004 14
19/07/2004 15
26/07/2004 16
02/08/2004 17
09/08/2004 18
16/08/2004 19
23/08/2004 20
30/08/2004 21
06/09/2004 22
13/09/2004 23
20/09/2004 24
27/09/2004 25
04/10/2004 26
11/10/2004 27
18/10/2004 28
25/10/2004 29
01/11/2004 30
08/11/2004 31
15/11/2004 32
22/11/2004 33
29/11/2004 34
06/12/2004 35
13/12/2004 36
20/12/2004 37
27/12/2004 38
03/01/2005 39
10/01/2005 40
17/01/2005 41
24/01/2005 42
31/01/2005 43
07/02/2005 44
14/02/2005 45
21/02/2005 46
28/02/2005 47
07/03/2005 48
14/03/2005 49
21/03/2005 50
28/03/2005 51
04/04/2005 52
You could start with the ATP Weeknum function, or read this:
http://www.cpearson.com/excel/weeknum.htm
I see your year starts on my week 16. So you'd have to subtract 15 from
the weeknumber. I hope you can work it out yourself how to make the
"negative" weeknumbers work in your system.
--
Amedee Van Gasse
To top-post is human, to bottom-post and snip is sublime.
Dit bericht is geplaatst in een nieuwsgroep. Post je evt antwoord of
vervolgvraag graag in dezelfde thread in de nieuwsgroep a.u.b.