Hey, So the basic concept is that he dates are for PPM Schedule so which means whenever it was left off, it has to be done in 2015, and the ones which have not been taken care off needs to begin on 15th Jan 2015
if you look at the column, some dates are in 2014 some dates are before 2014 some dates do not exist what I want is a formula so that the dates in 2014 should become 2015 and dates before 2014 should also have the year 2015 and the ones with no dates to show 15 Jan 2015 Could you help me please asap... I have so many of these columns to fill.... Thanks in advance Ajay -- 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 http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
DATES.xlsx
Description: MS-Excel 2007 spreadsheet