Excel in XL
An educational blog for excellence in Microsoft Excel
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 + ;
Older Posts
Home
Subscribe to:
Posts (Atom)