G
Guest
I need to combine the following 2 IF statements, or find a different formula
to make this happen.
=IF($K$6="","",$K$6+14)
=EOMONTH(K6,0)
K6 is the starting date of a payperiod, so the first formula goes to the
15th of the month. The second formula is needed if the start of the payperiod
is the 16th.
to make this happen.
=IF($K$6="","",$K$6+14)
=EOMONTH(K6,0)
K6 is the starting date of a payperiod, so the first formula goes to the
15th of the month. The second formula is needed if the start of the payperiod
is the 16th.