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??
route217Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Michael FowlerConnect With a Mentor Solutions 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.