Hello Experts,
I need help in writing a formula that would return a specific number into a blank cell based on a date that is inputted in a certain cell.
Example any date in July ( ie: Jul 1- 31) that is inputted in let say cell A5, i want the number 1 to be returned in cell B5. Any date in August that is inputted in cell A5 the formula should return 2, etc. Please see Month and period number below.
Jul = Period 1
Aug = Period 2
Sep = Period 3
Oct = Period 4
Nov = Period 5
Dec = Period 6
Jan = Period 7
Feb = Period 8
Mar = Period 9
Apr = Period 10
May = Period 11
Jun = Period 12
Thanks,
HB
Bookmarks