Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Date fomula not working
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="FangYR, post: 3810329"] Now, what I have done last year was, type =DATE(YEAR(A2)-1,MONTH(A2),DAY(A2))-(MONTH(DATE(YEAR(A2)-1,MONTH(A2),DAY(A2)))<>MONTH(A2)) in G2("a dummy cell"), in order that my date entry in A2 will be as last year, eg. enter 1/3 in A2, it will appear as 3 Jan 2008, not the default current year. This was ok in my last year workbook, ie, the date appear as 2007. Now it's not working. Help! [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Date fomula not working
Top
