| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validate same month and same year
Got help here figuring out the formula to validate that 2 dates in another
cell (not the one with the validation formula) were for the same month. I now need to validate they are both the same month and year. I've tried: =MONTH(H7)=MONTH(I7)and=year(H7)=year(I7) which XL doesn't accept. I tried =(MONTH(H7)=MONTH(I7))and(year(H7)=year(I7)) but that doesn't work either. Any suggestions? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Validate same month and same year
On Mon, 13 Jul 2009 08:53:09 -0600, salgud
wrote: Got help here figuring out the formula to validate that 2 dates in another cell (not the one with the validation formula) were for the same month. I now need to validate they are both the same month and year. I've tried: =MONTH(H7)=MONTH(I7)and=year(H7)=year(I7) which XL doesn't accept. I tried =(MONTH(H7)=MONTH(I7))and(year(H7)=year(I7)) but that doesn't work either. Any suggestions? Try this formula: =AND(MONTH(H7)=MONTH(I7),YEAR(H7)=YEAR(I7)) Hope this helps / Lars-Åke |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Validate same month and same year
On Mon, 13 Jul 2009 14:54:58 GMT, Lars-Åke Aspelin wrote:
=AND(MONTH(H7)=MONTH(I7),YEAR(H7)=YEAR(I7)) Thanks Lars! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count month when date is in day/month/year format | Excel Worksheet Functions | |||
| Tell me which "season" (Month/Day through Month/Day) a date(Month/Day/Year) falls in (any year)??? | Excel Discussion (Misc queries) | |||
| Sort month/date/year data using month and date only | Excel Discussion (Misc queries) | |||
| trying to get day/month/year froamt while user enters year only | New Users to Excel | |||
| Formula to return last day of month for each month in year? | Excel Programming | |||
Linear Mode
