| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date format
i have a monthly work sheet where i use days through out the month ex.
04/01/2007 04/12/2007 04/15/2007 etc. when april is over and I want to change the month only how to I change from 04 to 05? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date format
=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))
-- David Biddulph "dar" wrote in message ... i have a monthly work sheet where i use days through out the month ex. 04/01/2007 04/12/2007 04/15/2007 etc. when april is over and I want to change the month only how to I change from 04 to 05? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date format
Check all the answers that you have in your original post!
Please don't start multiple threads about the same question. Your original subject was "Dates", not too descriptive, But since there are numerous posts with that subject line, your original is grouped with them, somewhere in God's country, way down the list. That's why it's a good idea to be a little "original" and descriptive when titling your subject. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "dar" wrote in message ... i have a monthly work sheet where i use days through out the month ex. 04/01/2007 04/12/2007 04/15/2007 etc. when april is over and I want to change the month only how to I change from 04 to 05? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date format
Sun, 8 Apr 2007 08:44:02 -0700 from dar
: i have a monthly work sheet where i use days through out the month ex. 04/01/2007 04/12/2007 04/15/2007 etc. when april is over and I want to change the month only how to I change from 04 to 05? Please don't post the same query multiple times. This isn't a live chat room, and you need to allow a few hours for responses to start. Depending on the question, it may be days later that you're still getting responses -- or you may get none. Welcome to Usenet. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: I enter date and format for date, but shows as number | Excel Discussion (Misc queries) | |||
| Can I change a date with no format (20051111) to date format? | New Users to Excel | |||
| day/month/year in incorrect format for date format | Excel Worksheet Functions | |||
| How can I convert a date format to an ISO week format (in EXCEL)? | Excel Discussion (Misc queries) | |||
| Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) | |||
Linear Mode
