Copy a number from one cell to another depending on first number
I have a column with dates and want to copy dates into another cell depending
on the month number |
Marcia,
Perhaps: =IF(MONTH(A1)=1,A1,"") Format the cell as a date. HTH, Bernie MS Excel MVP "marcia driscoll" <marcia wrote in message ... I have a column with dates and want to copy dates into another cell depending on the month number |
It worked. Thank you very much
"marcia driscoll" wrote: I have a column with dates and want to copy dates into another cell depending on the month number |
It worked. Thank you
"Bernie Deitrick" wrote: Marcia, Perhaps: =IF(MONTH(A1)=1,A1,"") Format the cell as a date. HTH, Bernie MS Excel MVP "marcia driscoll" <marcia wrote in message ... I have a column with dates and want to copy dates into another cell depending on the month number |
All times are GMT +1. The time now is 05:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com