Calculating fiscal month number in Excel

This has come via this post at Mr Excel. and a response provided by Ron Coderre. Assuming the fiscal year starts in April, the formula below will give you the fiscal month. =MONTH(EDATE(A1,9)) The value of '9' is derived by the months remaining in the year that are the new financial year. In this case … Continue reading Calculating fiscal month number in Excel

Inbox wrangling

A few months ago I started using a tickler file like system in outlook. My inbox got removed from sight and I moved e-mails from there to a 'working folder' a couple of times a day.  This worked well, but there was a lot of moving e-mails about. This was annoying as there is enough metadata … Continue reading Inbox wrangling