Excel 2003
I have been struggling with a formula for the following and am getting
desperate:
1) Need a formula that will change a date to "1/04/05" when it is before
that date but must be able to leave any date alone that is after 1/04/05.
2) In a separate column I need another formula that will change a date to
"31/03/06" if the date is after that but will leave alone any date that is
before 31/03/06.
I have two formula's for the 1) scenario but I need them to work together to
achieve the result I need for that scenario. The date value comes from a
paste link cell.
=IF(C2>1/04/2005,1/04/2005,"1/04/05")
=IF(C2>1/04/2005,C2,C2)
Would these work if joined together and if so how?
Pleasssseee Help!
bj has helped but I think I take too long to reply back due to time zone.
Sue