Link to home
Create AccountLog in
Avatar of route217
route217Flag for United Kingdom of Great Britain and Northern Ireland

asked on

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??
ASKER CERTIFIED SOLUTION
Avatar of Michael Fowler
Michael Fowler
Flag of Australia image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of route217

ASKER

Thanks for the feedback

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