•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Formula needed (Adding Months to a Specific Month)
Our take
Are you struggling to calculate the "Next Inspection Month" based on your last inspection date and frequency? It’s a common challenge when working with legacy spreadsheets. But fear not—AI-native spreadsheet technology can simplify this process. By leveraging intelligent formulas, you can automatically generate the next inspection dates without having to input specific dates. Keep reading to discover a straightforward solution that will save you time and enhance your inspection scheduling efficiency.
Issue:
Last Inspection Month / Frequency of Inspections
November Semi-annual
January Monthly
October Semi-annual
November Quarterly
November Quarterly
October Quarterly
November Quarterly
October Semi-annual
Based on column A and Column B, I want to create a Column C named “Next Inspection Month”, and I’m having issues in creating the right formula.
I have tried using the EDATE function, but because I’m not inputting a specific date it is not helping me.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience