Showing posts with label fn: Date & Time. Show all posts
Showing posts with label fn: Date & Time. Show all posts

Sunday, February 26, 2017

Find a Quarter Number from Given Date

A custom formula using two functions and return quarter number from given date, based on calendar year.

   =ROUNDUP(MONTH(A1)/3,0)

Tuesday, February 21, 2017

Insert system date or time (Shortkey)

Shortcut keys to insert system date or time in a cell

for date ... Ctrl + ;
for time ... Ctrl + Shft + ;