Valentine's Day

[Expiry]

I thought I would share my favourite valentine's formula with you all.

I sent this to my wife as a Valentine's Card, a couple of years ago but she didn't appreciate it as much as I know you will:

=IF(AND(MONTH(TODAY())=2,DAY(TODAY())=14),"I love you","Where's my dinner, woman?")

 

[Joe4]

Being the Excel geeks that we are, we can shorten up that formula for you:

=IF(TEXT(TODAY(),"mdd")="214","I love you","Where's my dinner, woman?")

 

[VoG]

I would be in deep doo doos for forgetting Mrs VoG's card today if it weren't for the fact that she is currently flying out to Tenerife with a friend (and without me ).

 

[Jonmo1]

I'm buying the wife a House...I think I'm covered..
But delivered flowers to her work anyway...

 

[rpetkevi]

 

[Firefly2012]

I think I'm in it deep tonight - I haven't got anything arranged (card, flowers, nothing at all)

 

[JamesW]

Firefly, I totally read that wrong...

 

[Expiry]

Being the Excel geeks that we are, we can shorten up that formula for you:

=IF(TEXT(TODAY(),"mdd")="214","I love you","Where's my dinner, woman?")

I like that.

 

[Firefly2012]

Firefly, I totally read that wrong...

 

[rpetkevi]

Firefly, Go get chocolate at least, women like it!