skip to main
|
skip to sidebar
Excel Geek
Saturday, November 22, 2014
Date
DATE for today,
1.
Go to> Formula> Date & Time> Date
2.
In the Year text box enter Year(now())
3.
In the Month text box enter Month(now())
4.
In the Day text box enter Day(now())
5.
Click on OK
6.
You now have today’s date, 31-JUL-2012 as M/D/YYYY
0 comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
www.cineclouds.com. Powered by
Blogger
.
Popular Posts
Yesterday's Date Function in Excel
Using Tomorrow date function in Excel
PI circumference formula
Previous month date function in Excel
One week ago date function in Excel
Convert Number to Words (Indian Format)
SIN, COS and TAN Formulas
Year function
Date
Removing spaces
Blog Archive
►
2021
(8)
►
June
(2)
►
April
(1)
►
March
(5)
►
2015
(4)
►
December
(1)
►
April
(1)
►
January
(2)
▼
2014
(13)
▼
November
(2)
Date
SECOND
►
October
(1)
►
August
(1)
►
July
(1)
►
June
(1)
►
May
(1)
►
April
(2)
►
March
(3)
►
January
(1)
►
2013
(40)
►
December
(2)
►
October
(6)
►
April
(4)
►
March
(1)
►
February
(11)
►
January
(16)
►
2012
(38)
►
December
(3)
►
November
(12)
►
October
(22)
►
July
(1)
0 comments:
Post a Comment