[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 505
  • Last Modified:

Formula to show day of month

Is there an easy way to show the current day of month in a cell? So, if the current date is 25 May 2013, then I want 25 displayed in the cell. Tomorrow, it should change to 26 and so on.

Thank you
0
ank5
Asked:
ank5
2 Solutions
 
zorvek (Kevin Jones)ConsultantCommented:
=DAY(A1)

or

=DAY(NOW())

Kevin
0
 
Saqib Husain, SyedEngineerCommented:
=DAY(TODAY())
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now