Windows 7 Forums


Windows 7: Date questions...Excel 2007

04 Nov 2010   #1

Home Premium 64 bit
UK, Hampshire
 
 
Date questions...Excel 2007

Question 1.

Is there a formula to make the period between two dates inclusive other than adding "+ 1" to the result from DATEDIFF?



Question2.

DATEDIFF counts Leap Days (29th Feb) is there a way to automatically exclude them from a DATEDIFF count?
My System SpecsSystem Spec

Reply

 Date questions...Excel 2007 problems?



Thread Tools



Similar help and support threads for: Date questions...Excel 2007
Thread Forum
Separating date and time in Excel Office 2007 Microsoft Office
Cannot access the Ribbon functions in Excel 2007 or Word 2007 Microsoft Office
Solved What is Excel Date Playing At? Microsoft Office
Excel 2007: a question about date and time manipulation Software
Can't open 2003 Excel Files in Excel 2007? Microsoft Office


All times are GMT -5. The time now is 10:38 PM.


Seven Forums Android App Seven Forums IOS App Follow us on Facebook

Windows 7 Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows 7" and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32