[Webinar] Streamline your web hosting managementRegister Today

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

Date formula error

Hi Experts

I am using in cell c2 the following formula =Date(Year(Currentdate),Month(CurrentDate),0)
And getting 31 March 2011 as the returned result
When I need today's date

And in cell b2 I have =Date(Year(c2),month(c2),0) and so on for a2


What's wrong here??
0
route217
Asked:
route217
  • 2
1 Solution
 
Michael FowlerSolutions ConsultantCommented:
To get the current date just use =NOW() and format the cell to display the date in the appropriate format

Michael
0
 
route217Author Commented:
Thanks for the feedback

So how would I get dec12 in cell b2 depending on the date in cell c2 less one month
0
 
route217Author Commented:
Solved....
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

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