| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with date formula
The formulas below are used to return a date in 2 seperate boxes on my
spreadsheet how can i get the year 1900 to read 2006 =IF(AND(E7=2006,D7=0,C7=0),DATE(2006,1,1),DATE(E7, D7,C7)) This returns 31st July 2006, which is correct =IF(AND(I7=2006,H7=0,G7=0),DATE(2006,1,1),DATE(EI7 ,H7,G7)) This returns 20th August 1900, should be year 2006 I am not good with formulas so cant for the life of me see whats wrong, Can someone spot the mistake for me. thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with date formula
Just a small typo:
=IF(AND(I7=2006,H7=0,G7=0),DATE(2006,1,1),DATE(EI7 ,H7,G7)) probably should be: =IF(AND(I7=2006,H7=0,G7=0),DATE(2006,1,1),DATE(I7, H7,G7)) -- Gary''s Student "S S" wrote: The formulas below are used to return a date in 2 seperate boxes on my spreadsheet how can i get the year 1900 to read 2006 =IF(AND(E7=2006,D7=0,C7=0),DATE(2006,1,1),DATE(E7, D7,C7)) This returns 31st July 2006, which is correct =IF(AND(I7=2006,H7=0,G7=0),DATE(2006,1,1),DATE(EI7 ,H7,G7)) This returns 20th August 1900, should be year 2006 I am not good with formulas so cant for the life of me see whats wrong, Can someone spot the mistake for me. thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with date formula
Spot on, Many thanks for helping me.
"Gary''s Student" wrote in message ... Just a small typo: =IF(AND(I7=2006,H7=0,G7=0),DATE(2006,1,1),DATE(EI7 ,H7,G7)) probably should be: =IF(AND(I7=2006,H7=0,G7=0),DATE(2006,1,1),DATE(I7, H7,G7)) -- Gary''s Student "S S" wrote: The formulas below are used to return a date in 2 seperate boxes on my spreadsheet how can i get the year 1900 to read 2006 =IF(AND(E7=2006,D7=0,C7=0),DATE(2006,1,1),DATE(E7, D7,C7)) This returns 31st July 2006, which is correct =IF(AND(I7=2006,H7=0,G7=0),DATE(2006,1,1),DATE(EI7 ,H7,G7)) This returns 20th August 1900, should be year 2006 I am not good with formulas so cant for the life of me see whats wrong, Can someone spot the mistake for me. thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Trending Formula Results by Date | Excel Worksheet Functions | |||
| Year-to-date year to date formula | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
Linear Mode
