•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)
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]
Want to read more?
Check out the full article on the original site