How do I use the IF formula to flag me 21 days after the date?

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

Guest

I need to set up a spreadsheet that will flag me when it is 21 days past the
date I input originally.
 
Wanderer --

Howze about:

A
1 Date
2 =IF(TODAY()-A1>21,"Holy cow!","")

Should do the trick. HTH
 
You must log in or register to reply here.

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

Similar Threads

How do I use the IF formula to flag dates 21 days prior to deadlin 1
alarm on a date cell? 2
Happy Anniversary Flag? 4
Happy Birthday Formula Flag Needed 12
how do i know date after no. of working days 6
Help with a formmula change in a "flag" parameter! 19
Testing a cell value for a specific weekday. 3
Triggering a Flag after 10 days that excludes weekends and holiday 3

Back
Top