=IF(TODAY????

[marz73]

I am trying to copy data in to cell S3 from one of the cells in Q3 to Q14 as long as todays date falls in the range of the corresponding month. The corresponding month for that colum is in M3 to M14 and N3 to N14 as listed first and last dates of the month. Any help would be greatly appreciated!

 

[James006]

Hi,

Why not using your Columns M and N to filter your data ?

 

[marz73]

Hi,

Why not using your Columns M and N to filter your data ?

I'm using the data in cell S3 for an approval details in power automate flow

 

[marz73]

I got it to work using =INDEX(Q:Q, MATCH(MONTH(TODAY()), MONTH(M:M), 0)) rather than an IF function. thanks to all that looked this over.