Function for days between dates and an if statement (HELP)

  • Thread starter Thread starter getmhawks
  • Start date Start date
G

getmhawks

I am trying to create a function where the time between two dates i
determined and if the amount of days is over 30 then their will be
red background placed in the cell. This maybe too complicated. I
that will not work then the cell beside the cell that has th
difference of the dates would have "overdue" written in red. Is thi
possible? I did figure out how to get the days between the two dates.
Any help would be greatly appreciated.

Andre
 
Why not just use conditional format for cell value over 30?

and then in the cell next to it. just put

=IF(A1>30, "OVERDUE", ""
 

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

Excel Excel due and overdue date colours 2
Ignore blank cells when calculating date for If, Then function 2
Excel High lightng dates in future, today and past 1
conditional formating with dates 1
Need to calculate the number of days between two dates on a 30 day 5
Date Conditional Formatting 4
If then between two dates 1
Need help with "if" formula 4

Back
Top