| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Equation Referencing Row Number Stored in Cell | Excel Discussion (Misc queries) | |||
| Changing cell or text color depending on week number | Excel Discussion (Misc queries) | |||
| How do I format a cell for a custom part number? | Excel Discussion (Misc queries) | |||
| spread the number 123.45 so each digit goes to a different cell | Excel Worksheet Functions | |||
| Unable to Copy COUNTA() with cell references | Excel Worksheet Functions | |||
Linear Mode
