Test to days date against another date

[pjpienaar]

I have in A1 a date 27-June-14 in B1 5 years and in C1 27-June -19 which indicated that from date in A1 5 years later the date in C1 will display 27-June-19 (Formula is A1+1826)

I want to use a IF function in D1 to test C1 when two months is left to flag with "Due"

Help will be appreciated

 

[bines53]

Hi

You can upload a file?

David

 

[pjpienaar]

Here is a sample file David

 

[bines53]

Hi,

You mean,=(C3-61)<=TODAY()

David

 

[pjpienaar]

If you look at the sample file you will see a Due Date column with a date in it, in the cell next to that I want to use a IF statement to say "Due" two months from the date

 

[bines53]

Hi,

I'm sorry, I can not understand ,

David

 

[pjpienaar]

Thank you David sorted it