Hello everyone. I'm a fairly basic Excel user and my need is beyond my skills. Basically I have a large form populated with thousand of dates. I need to figure out a way to get counts by year based on a fiscal calendar rather than a normal yearly calendar. My fiscal calendar is 10/1/xx - 9/30/xx. My thoughts are to have the dates reformatted to show as a year (based on fiscal timing) and then do a count function. My thought was to do an If/Then and put in the date range for a fiscal year and have it return a value that is only a 4 digit number for the fiscal year. (11/2/24 would return 2025). I've tried working with If/Thens but I'm not having any luck getting it to compare the selected cell to a date range. There may likely be other/better ways to get the results I want but I'm running into a wall. I'm uploading a small sample of my data set. Can anyone help?
| Book1 | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| B | C | D | E | F | G | H | |||
| 3 | 10/10/24 | 1/9/25 | 4/10/25 | 7/10/25 | |||||
| 4 | 5/29/25 | 5/27/27 | 5/24/29 | 5/22/31 | |||||
| 5 | 2/24/26 | 2/22/28 | 2/19/30 | 2/17/32 | |||||
| 6 | 2/24/26 | 2/22/28 | 2/19/30 | 2/17/32 | |||||
| 7 | 2/24/26 | 2/22/28 | 2/19/30 | 2/17/32 | |||||
| 8 | 6/25/25 | 6/23/27 | 6/20/29 | 6/18/31 | |||||
| 9 | 2/24/26 | 2/22/28 | 2/19/30 | 2/17/32 | |||||
| 10 | 2/24/26 | 2/22/28 | 2/19/30 | 2/17/32 | |||||
| 11 | 2/24/26 | 2/22/28 | 2/19/30 | 2/17/32 | |||||
| 12 | |||||||||
| 13 | |||||||||
| 14 | |||||||||
| 15 | |||||||||
| 16 | |||||||||
Sheet1 | |||||||||
