Help with formula

S

ss

Help with formula please...

Cell E6 next departure date
Cell E7 current 180 day visa started on .. date
Cell M7 180 day visa expires on..E7+180
Cell M8 next exit date -180 days ..E6-180

Cells C12:C17 are arrival dates
Cells D12:D17 are departure dates
Cells E12:E17 are days (departure - arrival)

In cell M9 I require a formula to take M8 and total any dates from
C12:C17, D12:D17 that are within that date frame.

This is for a visa that takes your next exit date rolls back 180 days
and then checks to see if you have used the allocation of an allowable
90 days in the country.
 
S

ss

Help with formula please...

Cell E6 next departure date
Cell E7 current 180 day visa started on .. date
Cell M7 180 day visa expires on..E7+180
Cell M8 next exit date -180 days ..E6-180

Cells C12:C17 are arrival dates
Cells D12:D17 are departure dates
Cells E12:E17 are days (departure - arrival)

In cell M9 I require a formula to take M8 and total any dates from
C12:C17, D12:D17 that are within that date frame.

This is for a visa that takes your next exit date rolls back 180 days
and then checks to see if you have used the allocation of an allowable
90 days in the country.
Click to expand...

now sorted
 

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

Formula to fill cells based on Date of Arrival and Date of Departure 1
Payment calculation 1
Help with Conditional Formula 7
Conditional Formatting - Cannot get it to work, please help 1
help with formula 4
PLEASE HELP TO MATCH ALL SHEET AND THEN MERGE, 1
Formula help 3
Help with date/cost formula 6

Top