I have a column with dates and want to copy dates into another cell depending on the month number
M marcia driscoll May 3, 2005 #1 I have a column with dates and want to copy dates into another cell depending on the month number
B Bernie Deitrick May 3, 2005 #2 Marcia, Perhaps: =IF(MONTH(A1)=1,A1,"") Format the cell as a date. HTH, Bernie MS Excel MVP
M marcia driscoll May 3, 2005 #4 It worked. Thank you Bernie Deitrick said: Marcia, Perhaps: =IF(MONTH(A1)=1,A1,"") Format the cell as a date. HTH, Bernie MS Excel MVP Click to expand...
It worked. Thank you Bernie Deitrick said: Marcia, Perhaps: =IF(MONTH(A1)=1,A1,"") Format the cell as a date. HTH, Bernie MS Excel MVP Click to expand...
