Changing date format based on fiscal years versus calendar years

fr4nk

New Member
Joined
Aug 7, 2024
Messages
2
Office Version
  1. 2021
Platform
  1. Windows
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
BCDEFGH
310/10/241/9/254/10/257/10/25
45/29/255/27/275/24/295/22/31
52/24/262/22/282/19/302/17/32
62/24/262/22/282/19/302/17/32
72/24/262/22/282/19/302/17/32
86/25/256/23/276/20/296/18/31
92/24/262/22/282/19/302/17/32
102/24/262/22/282/19/302/17/32
112/24/262/22/282/19/302/17/32
12
13
14
15
16
Sheet1
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Well I was able to find my own solution. I got the results I needed by using COUNTIFS formulas. Thanks just the same.
 
Upvote 0
Welcome to the MrExcel board!

Good to hear you figured out a solution. If you would like to post the actual solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.
 
Upvote 0

Forum statistics

Threads
1,224,542
Messages
6,179,424
Members
452,914
Latest member
echoix

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top