How do I display the 15th of the prior month? A1 = 09-05-07 B1 = display 08-15-07
D Deb Feb 6, 2007 #1 How do I display the 15th of the prior month? A1 = 09-05-07 B1 = display 08-15-07
M Mike Feb 6, 2007 #3 =((DATE(YEAR(A1),MONTH(A1),1))-31)+14 there must be a better way but it's all I could think of
R Ron Rosenfeld Feb 6, 2007 #4 How do I display the 15th of the prior month? A1 = 09-05-07 B1 = display 08-15-07 Click to expand... A bit different way: =A1-DAY(A1)-DAY(A1-DAY(A1))+15 --ron
How do I display the 15th of the prior month? A1 = 09-05-07 B1 = display 08-15-07 Click to expand... A bit different way: =A1-DAY(A1)-DAY(A1-DAY(A1))+15 --ron
