Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date formula
I need a formula that will determine if dates ( formatted xx/xx/xx)in column
B & C are = or greater than 1 year apart and if so to return value "Yes", if not return value "No". Thank you! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date formula
=IF(C1-B1=365,"Yes","No"
"hmsawyer" wrote: I need a formula that will determine if dates ( formatted xx/xx/xx)in column B & C are = or greater than 1 year apart and if so to return value "Yes", if not return value "No". Thank you! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date formula
If B1 contains the starting date and C1 contains the ending date then :
=IF(DATEDIF(B1,C1,"y")=1,"Yes","No") Dates are simply numbers. Excel's date range is Jan. 1, 1900 is day 1 and Dec. 31, 9999 is day 2,958,465. If you format those numbers as dates you'll see dates, but they are just numbers. Formatting does not change cell values. The DATEDIF function takes leap years into account. The function is documented in many books on Excel and at http://www.cpearson.com/excel/datedif.aspx Tyro "hmsawyer" wrote in message ... I need a formula that will determine if dates ( formatted xx/xx/xx)in column B & C are = or greater than 1 year apart and if so to return value "Yes", if not return value "No". Thank you! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date formula
What about Leap Years?
Rick "Mike" wrote in message ... =IF(C1-B1=365,"Yes","No" "hmsawyer" wrote: I need a formula that will determine if dates ( formatted xx/xx/xx)in column B & C are = or greater than 1 year apart and if so to return value "Yes", if not return value "No". Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Formula Problem - Leave date blank if Null | Excel Worksheet Functions | |||
Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) |