I am an Excel novice still using the simple excel 2003.
While I know how to get the week number, I want to now learn how to get the "semi-month" number using a formula.
For example A1 has the date, B1 would have formula to calculate the semi-monthly number
01 Jan = 01
15 Jan = 01
16 Jan = 02
13 Feb = 03
28 Feb = 04
10 Mar =05
25 Mar =06
07 May =09
17 May =10
16 July =14
31 July =14
While I know how to get the week number, I want to now learn how to get the "semi-month" number using a formula.
For example A1 has the date, B1 would have formula to calculate the semi-monthly number
01 Jan = 01
15 Jan = 01
16 Jan = 02
13 Feb = 03
28 Feb = 04
10 Mar =05
25 Mar =06
07 May =09
17 May =10
16 July =14
31 July =14