Formula: Percent of Fiscal Year passed

**jomili** · 12-03-2010, 03:56 PM

Assume cell A1 has today's date. Our fiscal year runs from October 1 through September 30 each year. What formula would I use to determine where today fits into my fiscal year, ie what percentage of the fiscal year has passed as of today?

Thanks in advance for any help I can get on this.

**Harley2** · 12-03-2010, 04:27 PM

The attach has one possible way

**jomili** · 12-03-2010, 04:39 PM

hey, that works well. That certainly gets me started. Thanks a lot!

**squiggler47** · 12-03-2010, 04:40 PM

=MOD((today()-(YEAR(TODAY())&"/10/1")),365.2425)/365.2425

will give the %age and automatically adjust each year!

**jomili** · 12-03-2010, 04:44 PM

Hey, now that's a useful one to keep around. I think I'll go with this, unless someone has something even shorter and sweeter.

Thanks,
John

**squiggler47** · 12-03-2010, 04:55 PM

After further thought

=MOD(A2-275,365.2425)/365.2425

works just as well 0.1% difference between this and the first formula which represents 1/3 of a day!

275 is the date of 1/10/1900

**jomili** · 12-03-2010, 06:32 PM

Thanks Squiggler. It's really cool when I get 3 workable solutions to my problems. Thanks for all your help.

**joninkim** · 04-24-2017, 06:31 AM

If this is accurate then all i need to do (adjusting to my fiscal year dates) is say, as of today, 04/24/17 we are at 80.59 % of the fiscal year with 18.4 to go
(07/01/16-06/30/17).
that helps me with knowing where i really am with the budget