Help with formula using an ampersand for year

[RunTime91]

Greetings...

I need a formula that provides calculations for random dates which may extend backwards into last year.

In A3 is an emp. hire date (which may be a date before this year) and I want to subtract from that date today's date

The formula doesn't error but since the hire date is entered as a date and the concatenation I use in the formula puts quotation marks on the date it provides the wrong result.

Any idea's would be great...

=IF(B3-A3<91,0,IF(A3<"3/1/"&YEAR(TODAY()),56,IF(AND(A3>="3/1/"&YEAR(TODAY()),A3<"5/1/"&YEAR(TODAY())),32,IF(AND(A3>="5/1/"&YEAR(TODAY()),A3<"9/30/"&YEAR(TODAY())),16,IF(A3>="10/1/"&YEAR(TODAY()),56,0)))))

 

[barry houdini]

Rather than using this construction for a date

"3/1/"&YEAR(TODAY())

Try using DATE function, like this

DATE(YEAR(TODAY()),3,1)

 

[RunTime91]

Genius!!

So cool ~! Thank You Barry!!