how to change the date format? Select the cell or column or range containing the date(s). Click Format -> Cells On the Number tab, click Date This will give you the various formats available. The ...
Question about Microsoft Office Computers & Internet
Changing dates format in a spreadsheet I am trying to tidy ip a spreadsheet whic has a combination of "English" style dates and "American" style dates. When I elect the dates I wish to change"the ...
Question about Microsoft Office Computers & Internet
Calculation of end date in format dd/mm/yy what is the formula,if a cell having start date of some batch, and i f i need to calculate the date after 15 month ? Assuming you put the start date in cell ...
Microsoft Access Query I have a query set so I pull DISTINCT dates in the SQL from 1/1/08 thru 12/31/08 to take out duplicate accounts, this works great when I run the report quarterly or yearly but I
Question about Microsoft Office Computers & Internet
Calculate Quarters between any two dates Example: Start Date: 27/03/2006 End Date: 19/08/2006 I need to calculate how many complete three month periods have passed between the two dates - this is not ...
Word automatically updates documents When I open a saved Word document, the date automatically updates to today's date. How do I shut off this feature in Word? Get rid of the date field. Just type the
...computer to an earlier time' and click Next Now you will find one Month Calendar window with Dates below, go to the previous month by clicking the '<' sign in the upper left ...
Question about Microsoft Office Computers & Internet
what is the formula,if a cell having start date of some batch, and i f i need to calculate the end date after 15 month ? Use this forumla =EDATE(A1,15) example in cell A1 you enter 3/11/2009 and in ...
date change I write and store business invoices. Every time I open an old invoice the date changes to the present day. Consequently I lose valuable information relating to the date the original ...
...their sheet and i then do my work from it.What I need to know is how can I put the Day and the Date in the header in the column on the right side of the page so that it will update each day. I ...
944 questions posted
Usually answered in minutes!
7,277 Questions
239 Questions
265 Questions
207 Questions