chaiyya345
New member
- Joined
- May 11, 2020
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016, 2019
Hi All,
I am creating a maternity register & wish to do the followings to the column E (Date Return to work):
From column D4 (Date Start) IF year is above 2018, then add 90 days, otherwise/anything <2018 add 60 days.
how to achieve the Date Return to work by looking at the year?
Thank-You very much
I am creating a maternity register & wish to do the followings to the column E (Date Return to work):
From column D4 (Date Start) IF year is above 2018, then add 90 days, otherwise/anything <2018 add 60 days.
how to achieve the Date Return to work by looking at the year?
Thank-You very much