Data in Cell dependant on drop down lists

K

kalahari

I'm trying to create an idiot-proof spreadsheet for our family business staff
wages:

I have made a drop down list from January - December,
and a second list from 2008 - 2019, these values form the headings of each
subsequent page inc. staff payslips.

I am able to select APRIL from a dropdown in cell B3; 2008 from a dropdown
in CELL B5 ... BUT .... when those are selected I would like cell B7 to
display
"Pay Period 29/03/08 to 28/04/08" (or the appropriate Pay period for the
month/year combination)
 
M

Max

So you have in B3: April, in B5: 2008. Assuming that additionally, the
number: 28 will be entered/selected in say: B4, then this expression placed
in B7 will return exactly what you're looking for:
=IF(COUNTA(B3:B5)<3,"","Pay period
"&TEXT(DATE(YEAR(--(B3&B5)),MONTH(--(B3&B5))-1,DAY(B4)+1),"dd/mm/yy")&" to
"&TEXT(DATE(YEAR(--(B3&B5)),MONTH(--(B3&B5)),DAY(B4)),"dd/mm/yy"))
 

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

Dependant drop-down lists allowing invalid entries 3
Calculate according to Drop Down control list value 1
add text to cell by clicking a choice in drop down list 1
Drop-down list dependant on another cell value 2
Dependant Dropdown lists using Combo Boxes 15
Use word to associate an item in validation drop down list 2
Drop down list selections creating values in adjoining cell 1
Drop Down Lists 3

Top