Formula for Between to Dates

Solved/Closed

Tom9o Posts 11 Registration date Monday February 18, 2013 Status Member Last seen September 15, 2013 - Feb 19, 2013 at 10:08 PM
Tom9o - Feb 23, 2013 at 06:21 AM

Hello,

Hi, I am looking for a date formula that will tell me if a date in a cell is between to dates In column "A" I have a list of dates and in cell "G1" I have 13/2/13 and in Cell "H1" I have 20/2/13. I am looking for an formula that will tell me if the dates in column "A" are between these two dates, if I run the formula in column "C" I am wanting the date if it is between the two dates to show up in the opposite cell in column C if it is not then it shows a blank in the opposite cell in column C, I guess an "IF" formula is required but I cannot work out how to show the between part for the two dates

Formula for Between to Dates
Logitech formula vibration feedback wheel driver - Download - Drivers
Date formula in excel dd/mm/yyyy - Guide
Number to words in excel formula - Guide
Credit summation formula - Guide
Formula bar in excel missing - Guide

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 20, 2013 at 01:10 AM

try
=IF(AND(A1<>"", A1>=$H$1, A1<=$G$1),A1,"")

Tom9o
Feb 23, 2013 at 06:21 AM

Hi rizvisa thanks for this have been away so this is whay the late responce, this works ok,

Thanks Tom9o

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel

How to calculate position (1st,2nd,3rd) in excel....?

formulas for 1st and 2nd position in class

Calculation of positions in excel

Use of '@' in formulae

Similar discussions

Subscribe To Our Newsletter!