How do I use the IF formula to flag dates 21 days prior to deadlin

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to set up a spreadsheet that will flag me 21 days from the date I
send out documents. So that I can follow up on those documents.
 
What do you have so far? You could do this with conditional formatting or
something like this to define the date 21 days (calendar) out

=date(year(A1),month(A1),day(A1))+21

Or a combination of the two
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top