Calculate Yes or No if date is greater than 90 days and less than 365 days

**Tashia** · 11-02-2017, 03:23 PM

Hello,

I am calculating dates and need help displaying Y or N for two entries. Please note, these are two separate formulas. Thank you in advance.

Date: 7/27/2017
>90 days
<365 days

**daddylonglegs** · 11-02-2017, 03:33 PM

What do you mean >90 days, in comparison to what, today's date?

This formula will give you "Y" if a date is more than 90 days old compared with today

=IF(A1< TODAY()-90,"Y","N")

follow the same logic for 365

**Tashia** · 11-02-2017, 03:53 PM

Got it! Thank you

Calculate Yes or No if date is greater than 90 days and less than 365 days

LinkBack

Thread Tools

Rate This Thread

Display

Calculate Yes or No if date is greater than 90 days and less than 365 days

Re: Calculate Yes or No if date is greater than 90 days and less than 365 days

Re: Calculate Yes or No if date is greater than 90 days and less than 365 days

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Calculate Uptime in Days within the constraint of Total Days in Each Month

[SOLVED] calculate total number of days between two days based on 365 days year

calculate date using A1 which is how many days ago calc in A2 to the date A1 days ago

How to calculate number of sick days taken in a rolling 365 days period based on colour

[SOLVED] VBA Less than Specific Date But No Greater Than 28 days

Calculate End Date Using Start Date and No. of Days excluding specific days.

Calculate total working days and excepted leave days

Bookmarks

Bookmarks

Posting Permissions