Date if function [Closed]

Report
-
Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
-
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


1 reply

Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
136
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!