​​
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.

Attachment: DATES.xlsx
Description: MS-Excel 2007 spreadsheet

Reply via email to