Relating today to other dates Closed

Question

Hello, 

=IF(M38>=A197;(M38);(O38))

M38 - date for the first payment
A197 - =Today()
O38 - date for the second payment

What I wanted with this formula was for the date for the first payment to show up if that date was superior or equal to today's date, if not, then the date for the second payment would appear.

However, in excel I always get the date for the first payment. Could you help me please?

Thank you so much,

Carolina
Configuration: Mac OS X (10.11.2) / Safari 9.0.2

vcoolio · Answer

Hello Carolina,

Make the following adjustments to your formula:-

From:-

=IF(M38>=A197;(M38);(O38)) 

to

=IF(M38>=A197,M38,O38)

I'm assuming that you know that the formula needs to be placed in any cell other than M38, A197 or O38 otherwise you will receive a circular reference error with the result being 0.

I hope that this helps.

Cheerio,
vcoolio.

Relating today to other dates

1 response

Similar discussions

Subscribe To Our Newsletter!