2 cells with dates -blank reporting

Andrew Darley

Hi,

I have a cell "signoff" with date a that is manually entered and cell "required date" which is autogenerated from a look up.

In 3rd cell "timeframe met", I'm trying to report if "signoff" cell is <= "required date" then report Yes, if not report No -but if "signoff" cell is blank it currently reports back "yes" so need to add in a if is blank then report "No signoff date" rather than yes.

Formula so far:

=IF([Sign Off]@row >= [Required Date ]@row, "N", "Y")

Any ideas? Thanks

Bassam Khalil

Hi @Andrew Darley

Hope you are fine, please try the following formula and convert it to column format formula:

=IFERROR(IF(ISBLANK([Required Date]@row), "", IF(ISBLANK([Sign Off]@row), "No signoff date", IF([Sign Off]@row >= [Required Date]@row, "Yes", IF([Sign Off]@row < [Required Date]@row, "No")))), "")

the following screenshot shows the result:

Bassam Khalil

Hi @Andrew Darley

Hope you are fine, please try the following formula and convert it to column format formula:

=IFERROR(IF(ISBLANK([Required Date]@row), "", IF(ISBLANK([Sign Off]@row), "No signoff date", IF([Sign Off]@row >= [Required Date]@row, "Yes", IF([Sign Off]@row < [Required Date]@row, "No")))), "")

the following screenshot shows the result:

Andrew Darley

Bassam,

Many thanks -this looks like it has solved it.

Regards,

Andrew