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

Drop Down List Dependant Formula 2
Dependant drop-down lists allowing invalid entries 3
How do I designate dates using info from a cooresponding drop down list? 3
How to dynamically change the list in drop down list based on thevalue of another cell? 1
how to have 2 drop down lists filter rows 2
Use word to associate an item in validation drop down list 2
Data validation dependant drop down on unsorted list 6
Cell Drop Down in Excel 1

Top