1 min readfrom 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.

submitted by /u/MutedLeather9187
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article