R
Rizitsu
Unfortunately that only formats the date that i want to search with wit
the format of MMMM.
e.g. =TEXT(01/03/04,"MMMM") == March
I want to use 01/03/04 and see if it is withing any of my ranges,
date (1st range (service month one, service month two))
so in theory,
if date is in between 1st and 2nd ranges, start and finish dates.
then output the first month of the corresponding into the cell.
Regards
perhaps a harder solution that at first percieved
the format of MMMM.
e.g. =TEXT(01/03/04,"MMMM") == March
I want to use 01/03/04 and see if it is withing any of my ranges,
date (1st range (service month one, service month two))
so in theory,
if date is in between 1st and 2nd ranges, start and finish dates.
then output the first month of the corresponding into the cell.
Regards
perhaps a harder solution that at first percieved