DATE Function Dictionary

-
Function Dictionary Function Examples Function Categories

DATE        
 
   
Day Month Year Date
25 12 99 12/25/99  =DATE(E4,D4,C4)
25 12 99 25-Dec-99  =DATE(E5,D5,C5)
33 12 99 January 2, 2000  =DATE(E6,D6,C6)
What Does It Do?          
This function creates a real date by using three normal numbers typed into separate cells.
Syntax              
 =DATE(year,month,day)
Formatting            
The result will normally be displayed in the dd/mm/yy format.
By using the Format,Cells,Number,Date command the format can be changed.

Popular posts from this blog

TASK - 8

-
TASK - 8                             8a . Put in am / is / do / don't / does / doesn't                                         1. Excuse me, do you speak English?           2. "Have a cigarette, 'No, thank you, I ….. smoke.       3.  Why ….. You laughing at me?             4. What …. she do? She is a doctor.           5. I …. want to go out. It …. raining.             6. Where ….. You come from? ' From Australia'       ...
Read more

FORECAST Function Dictionary

-
Function Dictionary Function Examples Function Categories FORECAST             Month Sales 1 £1,000 2 £2,000 3 £2,500 4 £3,500 5 £3,800 6 £4,000     Type the month number to predict :  12     The Forecast sales figure is :  £7,997  =FORECAST(E11,F4:F9,E4:E9) What Does It Do ?             This function uses two sets of values to predict a single value. The predicted value is based...
Read more