Not a problem! Happy to help!


"artemis1027" wrote:

That worked, thank you!!!

"Sean Timmons" wrote:

=if(A1="","",DATE(YEAR(NOW()),MONTH(A1),DAY(A1))-1)

"artemis1027" wrote:

And if a spot is left blank, how do I get it to not automatically fill-in?

"Sean Timmons" wrote:

=DATE(YEAR(NOW()),MONTH(A1),DAY(A1))-1

"artemis1027" wrote:

I have a form that tracks when various visits are to be done and when they
were completed. One column is a reassesment visit and that is based off of
the consumer's start date (another column) and is to be completed 364 days
later (another column for the date complete), and every year after that. I
have it set to fill-in the visit date automatically, but it only shows it one
year from the start date. How do I get it to show a visit that is due this
year if the consumer started in 1995?