Library › Finance AI › FP&A and financial analysts
Age open requisitions as of today and flag the old ones
- For FP&A and financial analysts
- You practice Asking for a format you can use
- Time about 5 minutes
- Level Beginner
About this exercise
You're summarizing open requisitions for the CFO as of Nov 6, 2026. Write a prompt for a markdown table with columns Req | Role | Days open | Flag, sorted by days open from highest to lowest, then a line starting "Average days open:" with the math to one decimal. Flag is "Over 60 days" when open more than 60 days. Don't mention recruiter excuses or comment on any hiring decision. No commentary. Under 80 words.
Common mistakes when you ask AI for this
- Counting from the wrong date. The AI counts months instead of calendar days. Try: Say: "Days open = Nov 6 minus the opened date."
- Echoing recruiter notes. The AI adds why R4 is hard to fill. Try: Add: "Do not mention recruiter notes."
- Average without math. The AI gives 73 with no division. Try: Add: "Average days open: the four numbers added and divided by 4."
- Not sorted. The AI keeps the original order. Try: Say: "Sort by days open, highest first."
- Trusting the AI to count words. AI is bad at counting and runs past word limits. Try: Ask for fewer words than the real cap and keep each line short.
What a strong prompt includes
- Names the columns
- Asks for sorting
- Gives the flag rule
- Asks for the average line
- Bans the notes
Related exercises
- Accrue goods received but not invoiced at PO price (Finance AI · Accountants)
- Adapt one ad image to 3 sizes with Midjourney (Image & Video AI · Marketing and content)
- Age reconciling items and escalate those over 60 days (Finance AI · Accountants)
- Allocate shared rent by headcount using the right roster (Finance AI · Accountants)
- Announce a referral bonus with the steps to claim it (Marketing AI · HR and recruiting)