Skip to content

Instantly share code, notes, and snippets.

@andybateman

andybateman/Excel_Snippets.md

Created September 6, 2017 09:39
Show Gist options
  • Save andybateman/8c626c1058e73e6ebaea89fd8756faed to your computer and use it in GitHub Desktop.
Save andybateman/8c626c1058e73e6ebaea89fd8756faed to your computer and use it in GitHub Desktop.
Download ZIP
Great Excel Snippets
Raw
Excel_Snippets.md

Great excel snippets

=EDATE(B2,(YEAR(NOW())-YEAR(B2)+(IF(MONTH(B2)>=MONTH(NOW()),0,1)))*12)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment