Dates

Resolved · Low Priority · Version 2003

Thu 9 Jul 2009, 16:32 Delegate Sharon said...

Sharon has attended:
Excel Advanced course

Dates

How can I convert number of days accommodation requied for training courses into dates> Iwill send you the file under seperate cover.

Tue 14 Jul 2009, 09:41 Trainer Amanda said...

RE: Dates

Hello Sharon

Thank you for your question and welcome to the forum.

If you would like to email your spreadsheet to amanda@stl-training.co.uk with an explanation of what you would like to do with reference to the spreadsheet (e.g. which rows/columns of data you would like us to look at), we'll see what we can do.

Kind regards
Amanda

Wed 15 Jul 2009, 09:20 Trainer Amanda said...

RE: Dates

Hi Sharon

Thanks for sending your example through to me.

I have attached a copy of the spreadsheet, the formulas used are in the yellow cells. I

Attached files...

fcm hotel bookings.xls

Wed 15 Jul 2009, 09:39 Delegate Sharon said...

RE: Dates

Thank you Amanda this was a big help.

Excel tip:

Adding multiple rows in an Excel 2010 Worksheet

If you want to add more than one row to an Excel Worksheet, drag select the number or rows you want added to the spreadsheet.

Then right click on these selected rows, choose Insert from the menu, and the new rows will be added above the rows you first selected.

View all Excel hints and tips

Dates

Dates

RE: Dates

RE: Dates

Attached files...

RE: Dates

Excel articles

Excel tip:

Adding multiple rows in an Excel 2010 Worksheet