Need to write an IF statement for date ranges and show the week
I have a group of dates and I want to show what week of the year they fall into...
EX: 08/02/08 through 08/08/08 are in week 36 and 08/09/08 through 08/15/08 are week 37
EX: 08/02/08 through 08/08/08 are in week 36 and 08/09/08 through 08/15/08 are week 37
Computers & Internet - Oracle - Database Enterprise Named User Plus
Answers & Comments
Use weeknum on the start and end dates to know which weeks they fall
=weeknum(cell reference)