Need help with a If Date is older formula ?

General discussion on OpenOffice Calc and its spreadsheets.

Need help with a If Date is older formula ?

Postby Jill R. Lipe » Sat Oct 18, 2014 11:08 am

Hi,

I have a column of dates and I need a formula that displays Yes if the date is older than 547 days and No if not.

Here is what I tried but they all say Yes even if you enter yesterdays date.
=IF(R2>(TODAY()-547);"YES";"NO")

Can someone please offer a correction.

Thank-you!
Jill R. Lipe
 
Posts: 33
Joined: Mon Mar 24, 2014 6:30 am

Return to OpenOffice.org Calc

Who is online

Users browsing this forum: No registered users and 1 guest

cron