Date reference in a formula

KMan1190

Looking to create a formula that says if the date at the column called Chart Review Received is within the last 6 months, than display the value 1. If it is not, leave it blank.

This is what i have so far =IF(Chart Review Recieved<180)

Rachel.Graham

Hi,

I needed to identify when items were a week past due for a specific notification. Using NetworkDays, I have this: =IF([Target End Date]@row <> "", IF((NETWORKDAYS([Target End Date]@row, TODAY())) = 6, "Week", ""))

Thanks,

Rachel