Pay Period Dates Formula

[joditpg]

Hi,

I couldn't find the answer to this sorry if it was posted already:

I have a timesheet that I would like to autofill the payperiod end date once the pay period begin date is plugged in, BUT if the pay period begin date is left blank I would like this cell to also be left blank(currently it plugsi n a random date if pay period begin cell is left blank.)

What I've been trying so far is the following:

=IF(And(DAY(C3)<15,C3>0),DATE(YEAR(C3),MONTH(C3),15,if(day(c3)>15,DATE(YEAR(C3),MONTH(C3)+1,if(C3="",""))))

for Example if the pay period begin date is January 1, 2018, it would autofill January 15, 2018. That part I got to work by using this formula:=IF(DAY(C3)<15,DATE(YEAR(C3),MONTH(C3),15),DATE(YEAR(C3),MONTH(C3)+1,0))

So again the problem is if the pay period begin date is not filled in, a random weird date plugs into the pay period end cell - which I would like left blank.

Thank you!

 

[larryjfoster]

Try this
=IF(C3<>"",IF(DAY(C3)<15,DATE(YEAR(C3),MONTH(C3),15),DATE(YEAR(C3),MONTH(C3)+1,0)),"")