-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
fiscal month
-
C
Generating Month from Date for Fiscal Calendar
Greetings, <tbody> My data is in the format MM/DD/YYYY and I want to generate the fiscal month and number. Example: Cell contains 7/5/2017 and formula generates 1-Jul. I have tried using the Month and Choose functions. I can get the output to yield the correct month number, but not the...- Christina4
- Thread
- date formulas fiscal fiscal month month number
- Replies: 4
- Forum: Excel Questions
-
R
Need a more automated formula for estimating a 2 month run rate
Hello, Hopefully someone can help me here. I'm in the process of automating a report that gets written and I'm down to one final formula that I need help with. Currently I use this formula to calculate a 2 month run rate =(((N14/1)*5)+O14)/2 The '5' represents the number of weeks left in a...- rukiddin
- Thread
- fiscal month run rate
- Replies: 1
- Forum: Excel Questions
-
S
Formula to calculate Fiscal Month starting on January
Hi - Fiscal year in my company for 2012 started on 2nd of Jan 2012. Fiscal year in my company for 2013 started on 31st of Dec 2012 Because, our fiscal week always starts on a Monday. I'm trying to calculate fiscal month number for any given date between 2012 and 2013. Please help me write a...- SriniML
- Thread
- fiscal month
- Replies: 4
- Forum: Excel Questions
-
G
How do I vlookup a date to match a date range (period)?
On my first spreadsheet within a workbook, I have some data that looks like this: A B C D E F G... Year Period Week Ended MiscData1 MiscData2 MiscData3 Etc 2008 2/9/2008 abc efg hij klm...- gkisystems
- Thread
- calendar date range fiscal month period vlookup
- Replies: 4
- Forum: Excel Questions
