M
mrbalaje
If I input the date 11-Apr-2007 in Cell B1. Then the Cell A1 should
automatically display the first day of the month(1-Apr-2007) and the Cell C1
should automatically display the last day of the month(30-Apr-2007).
If i input 12-May-2007 in B1, then A1 needs to be 1-May-2007 and C1 needs to
be 31-May-2007.
Any way to get this?
automatically display the first day of the month(1-Apr-2007) and the Cell C1
should automatically display the last day of the month(30-Apr-2007).
If i input 12-May-2007 in B1, then A1 needs to be 1-May-2007 and C1 needs to
be 31-May-2007.
Any way to get this?