I Need some help. I want to calculated if data will uploaded on the 1st or the 15th based on today date. So for example if today is 11/27/2012 then the next data upload will be on 12/1/2012. And come 12/1/2012 next data upload will be on 12/15/2012. I've used formula below to calculate but when I enter any date after 12/15/2012 I get 1/1/2012 which is not what I need I need to tell me 1/1/2013
=IF(L1<=(DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(15))),(DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(15))),DATE(YEAR(TODAY()), MONTH(TODAY()) + (DAY(TODAY()) >= 15), 1))
Where L1 is todays current date.
=IF(L1<=(DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(15))),(DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(15))),DATE(YEAR(TODAY()), MONTH(TODAY()) + (DAY(TODAY()) >= 15), 1))
Where L1 is todays current date.