Using IF,AND, with DATEDIF

[AJWebb1]

I am trying to get excel to do a calculation for me based on information below. If Column F is blank I want Excel to calculate LOS Years, LOS Months, LOS Days with start date Column A and today. If Column F is not blank like below then I want Excel to calculate LOS years, LOS months, LOS days from date in Column A and Column F. I'm just at a loss for how I need to write this, everything I've tried has not worked.

Admit Date-Column A	LOS Years-Column B	LOS Months-Column C	LOS Days-Column D	Assigned to-Column E	Community Date- Column F
06/12/22					01/03/24

my last try was =If(F2="", DATEDIF(A2,Today(),"Y")) then I do the same thing in the Month column and days column but its not giving me the answer I'm looking for.

 

[Coyotex3]

Can you tell us what is the answer you are looking for? What is the calculation you are trying to get?

 

[Alex Blakenburg]

As Coyotex mentioned there are a couple intepretations of this although you seem to be missing the 2nd part of your if statement.

Book1
	A	B	C	D	E	F
1	Admit Date-Column A	LOS Years-Column B	LOS Months-Column C	LOS Days-Column D	Assigned to-Column E	Community Date- Column F
2	6/12/2022	1	2	24		1/03/2024
3	6/12/2022	1	2	9
Sheet1

Cell Formulas
Range	Formula
B2:B3	B2	=IF($F2="", DATEDIF($A2,TODAY(),"y"),DATEDIF($A2,$F2,"y"))
C2:C3	C2	=IF($F2="", DATEDIF($A2,TODAY(),"ym"),DATEDIF($A2,$F2,"ym"))
D2:D3	D2	=IF($F2="", DATEDIF($A2,TODAY(),"md"),DATEDIF($A2,$F2,"md"))