Ramona Winkelbauer started the topic Functional (and perhaps Fun with) Federally Focused Formulas in Excel in the forum Microsoft Productivity for Government 6 years, 10 months ago
I like formulas in Excel — especially those that add to the functionality of the data I’ve queried for. E.g., a quick formula for Fiscal Year adds to the functionality of a spreadsheet full of rows; assuming your date starts in J2, “=IF(MONTH(J2)<=9,YEAR(J2),YEAR(J2)+1)”.
Do other folks have functional or fun Federally focused formulas they’d like to share?
Poll of the Week
Could your inbox use a little more awesome?
Sign up to get a daily dose of awesome gov-focused resources, trainings, blogs and articles to help you do you job better.