I've been doing a lot of research and struggling to get the syntax down for "Column B." Any help is appreciated.
"Column A" is a manually entered date "ddmmyyyy." I want to calculate "Column B" automatically based on this date. If "Column A" is before March 1, 2016 the result in "Column B" should be [Column A]+100, if after March 1, 2016 the result should be [Column A]+50. The +100/50 represents days added to the date in "Column A."
Edit: Thanks for the responses. Column A is a date field set to date and time format, would that make a difference?
I input the formula as =IF([A]<1/3/2016,[A]+100,A+50) and the output is only providing the +50 regardless of date, unless Column A is blank in which case the result is +100. Any suggested changes appreciated.