| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match Date
If I have a date in date format, how can I match a value in the date.
For example, in cell A1 I type in 6/30/06. This is the month of June. In Cell B1, I want to create a formula that says essentially "If the Date is in the month of June then add 31 days" So I get 7/31/06 in cell B1. How do I do this? Thanks very much. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Match Date
=if(month(a1)=6,a1+31,"what should happen otherwise?")
(format as a date) SteveC wrote: If I have a date in date format, how can I match a value in the date. For example, in cell A1 I type in 6/30/06. This is the month of June. In Cell B1, I want to create a formula that says essentially "If the Date is in the month of June then add 31 days" So I get 7/31/06 in cell B1. How do I do this? Thanks very much. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Match Date
thanks.
"Dave Peterson" wrote: =if(month(a1)=6,a1+31,"what should happen otherwise?") (format as a date) SteveC wrote: If I have a date in date format, how can I match a value in the date. For example, in cell A1 I type in 6/30/06. This is the month of June. In Cell B1, I want to create a formula that says essentially "If the Date is in the month of June then add 31 days" So I get 7/31/06 in cell B1. How do I do this? Thanks very much. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| count between start date and end date | Excel Discussion (Misc queries) | |||
| Determining Date X based on Other dates | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
| NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
Linear Mode
