IF formula

[mabdulh1]

Hi, 

So here is what I need help with I am working with the below info. I need a formual that will look at this data and produce the output with number of days. Thats the easy part but since the data sometimes comes incomplete or isnt clean there needs to be some prework done. Below you will see 3 issues

1. The Start date doesnt fall within the year but I would like the number of days for it to output for that line =364

2. If both dates are there and its for the full year = 364 days

3. Missing Start date - Add the start date and then calculate the number of days (full year =364)

4. Missing End date - Add the year end date and then calculate number of days (full year = 364)

Thanks for your help in advance,

[fmvizcaino · Accepted solution]

Hi @mabdulh1 ,

Take a look at the attached example. In the formula, if the year was different than the current year, I have automatically inserted 364 even if the difference between the dates were less than 364.

Let me know if that works for you.

Best,

Fernando Vizcaino

[bpatel]

hi @mabdulh1 ,

is this what you are looking to do.. 

hope this helps or is on the right track!