CF for due dates

		Microsoft Office Forums > Microsoft Excel > Excel
CF for due dates

FAQ

Thread Tools

Display Modes

10-10-2017, 09:50 PM

mikehk

Windows 10 CF for due dates

Office 2013

Novice

Join Date: Sep 2017

Posts: 15

CF for due dates

I have tried these formulas but doesn't work...please help.
cell E4 has a due date (5 Oct 2017)

=AND($F4<>"Paid",TODAY()-DATE(YEAR(TODAY()),MONTH(TODAY()),$E4)>=6) for orange

=AND($F4<>"Paid",TODAY()-DATE(YEAR(TODAY()),MONTH(TODAY()),$E4)>=3) for blue

=AND($F4<>"Paid",TODAY()-DATE(YEAR(TODAY()),MONTH(TODAY()),$E4)>0) for green

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problem with Dates	Eric Tsang	Excel	1	09-30-2016 11:26 AM
Autofill dates - how can I get the same date and consecutive dates?	Exhale	Excel	3	04-05-2016 03:11 AM
Changing Actual Finish dates changes original Finish dates	SomewhereinTX	Project	3	12-20-2013 10:25 AM
Code to add dates	terricritch	Excel Programming	10	11-08-2011 09:51 AM
Calculating dates	Daria11	Word VBA	1	06-08-2011 06:54 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:32 PM.