Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tricky compare formula
Hi people,
I have a tricky question that I would like some help with please. Basically, I require a spreadsheet that lets you input 2 dates and then has some kind of formula that works out if the difference between the two dates is greater than, equal to or more than 31 days. It seems simple enough but I am finding it very tricky! Thanks, BWT |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tricky compare formula
With the newest date in A1 and the other one in B1:
=IF(A1-B1<31,"Smaller",IF(A1-B1=31,"Equal","Larger")) -- Kind regards, Niek Otten Microsoft MVP - Excel "BurntWithTime" wrote in message ... | Hi people, | I have a tricky question that I would like some help with please. | Basically, I require a spreadsheet that lets you input 2 dates and then has | some kind of formula that works out if the difference between the two dates | is greater than, equal to or more than 31 days. It seems simple enough but I | am finding it very tricky! | | Thanks, | BWT | | |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tricky compare formula
Thank you very much, works great!
"Niek Otten" wrote in message ... With the newest date in A1 and the other one in B1: =IF(A1-B1<31,"Smaller",IF(A1-B1=31,"Equal","Larger")) -- Kind regards, Niek Otten Microsoft MVP - Excel "BurntWithTime" wrote in message ... | Hi people, | I have a tricky question that I would like some help with please. | Basically, I require a spreadsheet that lets you input 2 dates and then has | some kind of formula that works out if the difference between the two dates | is greater than, equal to or more than 31 days. It seems simple enough but I | am finding it very tricky! | | Thanks, | BWT | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tricky Formula | Excel Worksheet Functions | |||
Tricky Formula | Excel Discussion (Misc queries) | |||
Help with a tricky formula...... | Excel Discussion (Misc queries) | |||
Tricky formula | Excel Discussion (Misc queries) | |||
tricky formula.. please help | Excel Programming |