Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Two Different dates in Excel 2000
Name: mqayyum Date: August 14, 2004 at 23:25:23 Pacific OS: Win 2000 CPU/Ram: P4-256
Comment:
I have two different date where I want to know the no. of days, weeks, months and year. Is there any formula in Excel 2000 which can help me to solve this problem.
Summary: I have an invoice created in Excel 2000 that automatically fills in today's date when I create the invoice. However, everytime I open that invoice at some future date, for example to record payment, t...
Summary: Hi, Please help me in comparing dates in Excel. Let the cells have dates as given below... A2 = 10-Jan-2009 B2 = 20-Feb-2009 C2 = 30-Mar-2009. I need a formula that checks if C2 is equal to an...
Summary: Actually, for your string you would need to use: =MID(A1,5,2)&"/"&RIGHT(A1,2)&"/"&(LEFT(A1,4)) With your string in A1, click on the cell where you want to see 03/14/2004 and paste in the formula. It c...
0 
