# Date if function [Closed]

-
Posts
1918
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 4, 2021
-
Hello,

I am looking for the formula to show the date if.

Ex: I have been provided with the start date (10/4/2016) and i need to add 28 day's (=A3+28) to the start date which will show the date as (11/01/2016), how ever, as a result date is lesser then 10th of the month (11/01/2016) then it should show 11/10/2016.. and if the resulted date is greater then 10th of the month (11/15/2016) it should show as 12/10/2016.

Start Date End Date Show Date
10/04/2016 (=A3+28) 11/01/2016 11/10/2016

11/14/2016 (=A3+28) 12/12/2016 01/10/2017

Posts
1918
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 4, 2021
142
Praveen, Good morning.

Try to use:

Show Date Cell -->
=IF(DAY(C2)<=10, DATE(YEAR(C2),MONTH(C2),10), DATE(YEAR(EDATE(C2,1)),MONTH(EDATE(C2,1)),10))

Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão