anitaturnbull
New Member
- Joined
- Feb 3, 2016
- Messages
- 4
I am trying to create a sick leave counter that counts leave days during the past rolling 12 months. I have the cell set up to count today as the end date if there is not an end date avaialable. Here is my set up.
Cell A2 is the start date (2/1/15)
Cell B2 is the return date (2/3/16)
Cell C2 is =IF(S2="","",(IF(B2>0,B2-A2,TODAY()-A2)))
If I use 2/1/15 as the start date in A2 and assume todays date 2/3/16 in B2, it returns an answer of 367. However, I don't want it to count it if it is more than 1 year old. Any ideas how I could accomplish this?
Cell A2 is the start date (2/1/15)
Cell B2 is the return date (2/3/16)
Cell C2 is =IF(S2="","",(IF(B2>0,B2-A2,TODAY()-A2)))
If I use 2/1/15 as the start date in A2 and assume todays date 2/3/16 in B2, it returns an answer of 367. However, I don't want it to count it if it is more than 1 year old. Any ideas how I could accomplish this?
