Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
change 12/5/2007 to 12/1/2005
I need a formula to add 2000 to the day, or the middle number between
the forward slashes, and make it the year and then make the day 1 or 15 or any number. Can anyone help with that. One problem is sometimes it's one digit and other times it's two. Ultimately, I'd like to graph the worksheet with the date (month, year) as the X axis. Alan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I update the 2005 attendance calendar to 2007? | Excel Worksheet Functions | |||
Excel 2007 problems with AS 2005 calculated members | Excel Discussion (Misc queries) | |||
I have a date 51231 (2005,dec,31) -I want to change to 2005/12/31 | Excel Worksheet Functions | |||
HOW DO I CHANGE ABSENCE TEMPLATE 2005, TO 2006 | Excel Worksheet Functions |