Function to capture Date with Month

D

Dolphinv4

Hi,

I have a column whereby the format is MM/YY. Then there
are rows where I put the dates the customers starts, ie,

A B C D E
Start
Date
1 07/04 08/04 09/04
2
3 3/7/04 1
4 8/8/04 1

I want it such that the cells in column C onwards to
recognise the date in B and put it accordingly to the
relevant columns C-onwards as show above. Currently I'm
doing this:

=IF(AND(B3>=$C$1,B3<$D$1),1,"")

So my qn is: is there anyway i can shorten the AND
(B3>=$C$1,B3<$D$1)? My formula is going to get more
complicate as I add other things. So I want to shorten
this as much as possible.

Thanks!
Val
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help on multiple criteria for formula and return a date 1
separating date and time 5
Distributing cell value (not text-to-columns) 7
Check if a date comes before/after a range of dates 0
sum working hours each month (sum hours in the last row for a monthin a table with dates) 3
Tried and true copy code lines fail me here 7
countifs Function not giving desired result with date criteria 2
Returning a Date with Multiple Criteria Lookup Values 0

Top