CCkfm2000
07-04-2011, 08:43 AM
Hello Excel Guru's
In cell C7 we have a date 31-Mar-2012 I need a formula to check if the date is the end of month and take a year off but add a day on so it should day 01-Apr-2011
If any other date in cell C7 e.g 28-Mar-2011 I need a formula to take a year off and add a day on so it should day 27-Mar-2011
Thanks
In cell C7 we have a date 31-Mar-2012 I need a formula to check if the date is the end of month and take a year off but add a day on so it should day 01-Apr-2011
If any other date in cell C7 e.g 28-Mar-2011 I need a formula to take a year off and add a day on so it should day 27-Mar-2011
Thanks