> > Hey Amar, > While doing manipulations with date you must ensure the Format of System date format.Some people use mm/dd/yyyy and others use dd/mm/yyyy so if someone has provide you the data in his format and you'r date format is different from that it will shows you the error.
Note one thing First date in Excel is 01-01-1900 means year 1900, Any date beyond this date will not be accepted in any computer format you're using therefore 30/12/1889 will show you error I changed your formula to make it a date which follows the date format rules. Means Month should not be greater than 12,dates should not exceeds 31. Please find the attached Data Regards, Mandeep Baluja -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Date formula.xlsx
Description: MS-Excel 2007 spreadsheet
