How do I write a formula in Google Sheets to find the current period in a fiscal year depending on today's date?
I'm trying to write a formula that determines the fiscal year period based on a July 1 start date. I would like quarter intervals for each period to signify which week of the month for the period as well. For example, right now it gives me period 11 because the month is May but it's technically period 10.25 at this point in time. It will truly be period 11 on May 30. I've attached an image of what I've tried so far.
Solution
What ended up working (at least for what I need) is actually using =DATEDIF(A11, today(), "D") and then dividing that number of days by 30.4347.
I got the 30.4347 by dividing 365.25 (ignoring centurial years, (365+365+365+366)/4 = 365.2425) by 12 months.
- Get weekday name from date in PySpark
- How can I calculate the number of working days between two dates
- Convert month name to number in PySpark
- How to get list of 2nd and 4th Saturday dates in SQL Server?
- Return month name in specified locale
- Spark dataframe string to month
- Change month numbers to month name in a dataframe (PySpark)
- Altering WinSCP timestamp, get file(s) from a specified date-named folder
- Map monthname to monthnumber in Azure Databricks using Scala
- SQL server: Get record with date closest to given date
- T-SQL How to select the nearest earlier date
- Find closest earlier date in SQL Server
- Convert Milliseconds to yyyy-MM-dd HH:mm:ss format Javascript
- Get period start of month period (bimester, trimester, quarter, and semester)
- Event load can't be found BC30590
- Excel - How to convert the combination of year, week number and day of week to calendar day?
- MySQL date format
- After ingesting a string using SSIS I am unable to convert into date format
- How to stretch an axis of type date in R?
- How to get current time and date in C++?
- get the last thursday before a date in PHP
- Convert date format in vue js with laravel
- Date and datetime support
- Excel - Nested IF(AND()) Statements to Report Multiple Parameters
- How to check whether an object is a date?
- Need efficient way to sort list of strings (dates) in Scala. (Avoiding the darkness of Java.)
- Proper way to parse a date as UTC using date-fns
- subtract days if date range contains dates from a list PHP
- Holidays - is there a java implementation?
- Need help to convert serial date to date format in Apps Script