| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change day of week to day of month
I have a row that contains days of the month - cell I3(DD). I want to read
the cell and change to to the day of the month - cell AE1(MM/DD/YYYY) using another cell that has the first day of the month entered - cell I5(MM/DD/YYYY). The reason I have to do this is because I will have to use the I5 cell data to do a vlookup afterwards. cell I3 = 2 cell AE1 = 04/01/2009 cell I5 = 04/02/2009 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Day, Week or Month | Excel Discussion (Misc queries) | |||
| Name The Week Of The Month | Excel Discussion (Misc queries) | |||
| Week of the Month | Excel Discussion (Misc queries) | |||
| Count Week Of Month | Excel Worksheet Functions | |||
| How do I change from a 7 day week to a 5 day week in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
