Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calendar in excel
Hi, I have an unusual question. I have a column of dates in excel, and I wanted to know how I could transfer that data into a calendar format without manually cuting and pasting each date. thanks! -- trynow ------------------------------------------------------------------------ trynow's Profile: http://www.excelforum.com/member.php...o&userid=31637 View this thread: http://www.excelforum.com/showthread...hreadid=513289 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
calendar in excel
You could copy a Sunday through Saturday date range, do an EDIT/PASTE SPECIAL
and check off the TRANSPOSE check box to get your first week started. If your first week of dates is in A1 through G1, move to the row where you want to start the second week and enter the formula =A1+7. Copy that formula across the row to G. You can then copy the entire row of formulas for the second week and paste if for each subsequent row, maintaining the same number of rows between weeks so the formulas will calculate correctly. -- Kevin Backmann "trynow" wrote: Hi, I have an unusual question. I have a column of dates in excel, and I wanted to know how I could transfer that data into a calendar format without manually cuting and pasting each date. thanks! -- trynow ------------------------------------------------------------------------ trynow's Profile: http://www.excelforum.com/member.php...o&userid=31637 View this thread: http://www.excelforum.com/showthread...hreadid=513289 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I create a calendar from excel data (schedule)? | Excel Discussion (Misc queries) | |||
display Calendar for Excel field entry? | Excel Worksheet Functions | |||
Excel 2003 Calendar Pop-Up Add-In | Excel Discussion (Misc queries) | |||
how do I adjust working calendar (6 day work week) in excel that . | Excel Worksheet Functions | |||
Pop up calendar won't show in Excel 2000 | Excel Discussion (Misc queries) |